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%'




when i do that i get record starting with A and K

why

please forget the other message