SELECT * FROM customer LEFT JOIN address ON customer.address_id = address.address_id LEFT JOIN city ON address.city_id=city.city_id where city.city like "N%"