/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 |