multiple LEFT JOIN HELP

[dflow]

this works

SELECT *
FROM apartments
LEFT JOIN country_list ON apartments.COUNTRY_ID = country_list.CountryID
WHERE apartments.ID =4201

 

 

this doesnt

SELECT *
FROM apartments
LEFT JOIN country_list ON apartments.country_ID = country_list.CountryID,
LEFT JOIN city_list ON apartments.city_id = city_list.CityID
WHERE apartments.ID =4201

 

i want to add several more left joins

[dflow]

ok the comma is the problem between the ",LEFT JOIN

SELECT *
FROM apartments
LEFT JOIN country_list ON apartments.country_ID = country_list.CountryID
LEFT JOIN city_list ON apartments.city_id = city_list.CityID
WHERE apartments.ID =4201