Sorry, the following query is invalid :
SELECT DISTINCT B.MATRICULE_PROPRIETE, B.IDENTIFIANT_BATIMENT, AD.CIVIQUE_MIN, AD.CIVIQUE, AD.TYPE_DE_VOIE, AD.LIEN, AD.VOIE, AD.EST_OUEST, B.DEPENDANCE, B.VESTIGE, B.NOM_HISTORIQUE FROM BATIMENT B, LIEN_BATIMENT_ENSEMBLE LBE, ADRESSE AD WHERE LBE.IDENTIFIANT_BATIMENT = B.IDENTIFIANT_BATIMENT AND LBE.IDENTIFIANT_BATIMENT = AD.IDENTIFIANT_BATIMENT AND LBE.IDENTIFIANT_ENSEMBLE = AND (AD.TYPE_ADRESSE = "principale" OR AD.TYPE_ADRESSE = "sans accès") AND B.DISPARU = 0 AND B.IDENTIFIANT_PROJET = 1 ORDER BY AD.VOIE, AD.TYPE_DE_VOIE, AD.EST_OUEST, AD.CIVIQUE_MIN
Erreur numéro : 1064
Message d'erreur : You have an error in your SQL syntax near 'AND (AD.TYPE_ADRESSE = "principale" OR AD.TYPE_ADRESSE = "sans accès") ' at line 8