>SELECT RATE_AERIEN.IDRATE_AERIEN AS IDRATE_AERIEN, > RATE_AERIEN.AEROPORT_DEPART AS AEROPORT_DEPART, > RATE_AERIEN.AEROPORT_ARRIVE AS AEROPORT_ARRIVE, > Compagnie_aerienne.nom AS nom > FROM RATE_AERIEN > LEFT OUTER JOIN Compagnie_aerienne ON Compagnie_aerienne.IDCompagnie_aerienne = RATE_AERIEN.COMPAGNIE_AERIENNE > WHERE Compagnie_aerienne.nom LIKE 'A%' >As this query is written, your LEFT JOIN isn't going to do you much good. You're only going to get the records that match the WHERE condition. If you want data from every RATE_AERIEN field matched only when the company begins with "A", you need to move the condition Compagnie_aerienne.nom LIKE 'A%' into the ON clause.