| /trunk/scripts/modules/cel/referonosaure.sql |
|---|
| 30,3 → 30,15 |
| AND nom_sel_nn = num_nom |
| ); |
| -- 31739 |
| UPDATE tb_cel.cel_obs c, tb_eflore.bdtxa_v1_00 a SET |
| c.nom_ret = CONCAT(a.nom_sci, ' ', a.auteur), |
| c.nom_ret_nn = a.num_nom, |
| c.nt = a.num_tax, |
| c.famille = a.famille |
| WHERE ( |
| nom_sel_nn IS NOT NULL AND nom_sel_nn != 0 |
| AND nom_referentiel like 'bdtxa%' |
| AND nom_sel_nn = num_nom |
| ); |
| -- 49 |