multi join query

SELECT

sakila_customer_0.first_name AS sakila_customer_0_first_name,

sakila_customer_0.last_name AS sakila_customer_0_last_name,

sakila_city_0.city AS sakila_city_0_city,

sakila_country_0.country AS sakila_country_0_country

FROM

sakila.customer sakila_customer_0

JOIN sakila.address sakila_address_0 ON

sakila_address_0.address_id = sakila_customer_0.address_id

JOIN sakila.city sakila_city_0 ON

(sakila_city_0.city_id = sakila_address_0.city_id

AND sakila_city_0.city_id IN('88', '89', '90'))

JOIN sakila.country sakila_country_0 ON

sakila_country_0.country_id = sakila_city_0.country_id ;