Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 752 | Rev 760 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 752 Rev 754
Line 28... Line 28...
28 
        nom_sel_nn IS NOT NULL AND nom_sel_nn != 0
 28 
        nom_sel_nn IS NOT NULL AND nom_sel_nn != 0
29 
        AND nom_referentiel like 'bdtfx%'
 29 
        AND nom_referentiel like 'bdtfx%'
30 
        AND nom_sel_nn = num_nom
 30 
        AND nom_sel_nn = num_nom
31 
       );
 31 
       );
32 
-- 31739
 32 
-- 31739
- 
 
 33 
 
- 
 
 34 
UPDATE tb_cel.cel_obs c, tb_eflore.bdtxa_v1_00 a SET
- 
 
 35 
       c.nom_ret = CONCAT(a.nom_sci, ' ', a.auteur),
- 
 
 36 
       c.nom_ret_nn = a.num_nom,
- 
 
 37 
       c.nt = a.num_tax,
- 
 
 38 
       c.famille = a.famille
- 
 
 39 
   WHERE (
- 
 
 40 
        nom_sel_nn IS NOT NULL AND nom_sel_nn != 0
- 
 
 41 
        AND nom_referentiel like 'bdtxa%'
- 
 
 42 
        AND nom_sel_nn = num_nom
- 
 
 43 
       );
- 
 
 44 
-- 49