1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
rs = connection.getStatement().executeQuery
( "SELECT compagnie.idcomp,compagnie.reference,compagnie.nom,compagnie.adresse," +
"localite.idlocalite,localite.codep,localite.ville,pays.idpays as idp,paysfr,perscont,"+
"compagnie.persconttel,compagnie.perscontfax,compagnie.perscontmail,compagnie.adressefac,"+
"compagnie.idlocalitefac as idlocfac,localite.codep as codepfac,localite.ville as villefac," +
"compagnie.idpaysfac as paysfac,pays.paysfr as paysfrfac,datefinac,compagnie.idcomptype," +
"comptype.libelle"+
" FROM compagnie"+
" JOIN localite ON localite.idlocalite = compagnie.idlocalite"+
" JOIN pays ON pays.idpays = compagnie.idpays"+
" JOIN comptype ON comptype.idcomptype = compagnie.idcomptype"); |
Partager