1 2 3 4 5 6 7 8 9 10
| SELECT NUM_ETAB, LIB_SIGLE , NOM_ETAB, ADR_ETAB, CP_ETAB, LIB_CANTON, TEL_ETAB, FAX_ETAB, CIVILITE, NOM_PERSONNE
from etablissement, sigle, commune, canton, chef_etablissement
JOINTURE
and NOM_ETAB like '%$etablissement%'
LIB_CANTON like '%$ville_etab%'
and LIB_SIGLE like '%$type_etab%'
and etablissement.NUM_ETAB in (select etablissement.NUM_ETAB
from etablissement, sigle, commune, canton, chef_etablissement
JOINTURE or etablissement.NUM_ETAB like '%$cle_etab')
ect... avec tous les champs) |
Partager