MySQL Using AND Statement I am having issues with this question:


  Find the cities that have direct (non-stop) flights to both Honolulu and Newark. 




The answer should be Dallas, since its the only location that has destinations to both Honolulu and Newark. I'm trying to use the AND statement but it wont work. 

SELECT FLIGHTS.source_city
FROM FLIGHTS
WHERE (FLIGHTS.destination_city = 'Honolulu') and (FLIGHTS.destination_city = 'Newark')


I am using MySQL.
FLIGHTS.destination_citycannot be the same value at the same time, therefore a join of the same table for each destination reference is required like:

SELECT f1.source_city
FROM FLIGHTS f1
JOIN FLIGHTS f2 ON f1.source_city = f2.source_city
WHERE f1.destination_city = 'Honolulu'
  AND f2.destination_city = 'Newark'
 ;