/trunk/doc/bdd/sql/tela/tb_del_cel_vues.sql |
---|
43,7 → 43,7 |
nom_sel, nom_sel_nn, nom_ret, nom_ret_nn, nt, famille, |
ce_zone_geo, zone_geo, lieudit, station, milieu, nom_referentiel, |
date_observation, o.mots_cles_texte, o.commentaire, |
o.date_creation, o.date_modification, o.date_transmission, certitude |
o.date_creation, o.date_modification, o.date_transmission, certitude, pays |
FROM tb_cel.cel_obs AS o WHERE o.id_observation IN (SELECT i.ce_observation FROM tb_cel.cel_images i) |
AND o.transmission = '1' ; |