mam takie dwie tabelki:
airports_list
id name
1 airport1
2 airport2
3 test
4 test1
group_travel_airports
id airport_id
1 1
2 1
Chciałbym wyciągnąć z tabeli airport_list rekordy niepasujące do group_travel_airports (test,test1).
Próbuję:
SELECT DISTINCT airports_list.id, group_travel_airports.airport_id FROM group_travel_airports LEFT JOIN airports_list ON group_travel_airports.airport_id = airports_list.id WHERE group_travel_package_id = 109