Selecting all data from multiple SQL tables... Quick FIX

[wispas]

I have 3 tables which i want to combine and select with one query...

 

Tables: city, hotel, gallery

 

I currently have:

SELECT * FROM city
INNER JOIN hotel
ON hotel.hotel_city_code = city.city_code
WHERE city_id=1

 

This will join the hotel and city together perfectly allowing me to select all of the data from hotel and city with the matching city code, but i want to also join the gallery table as well in the same query and have its city code match the city city code and am getting syntax errors... Heres what i have tried and still working on:

 

SELECT * FROM city
INNER JOIN hotel, gallery
ON hotel.hotel_city_code = city.city_code
AND gallery.gallery_city_code = city.city_code
WHERE city_id=1

 

Anyone can provide me with a quick fix? Cheers!

[wispas]

no worries... i figured it out...

 

SELECT *
FROM city
INNER JOIN hotel, gallery
WHERE hotel.hotel_city_code = city.city_code
AND gallery.gallery_city_code = city.city_code
AND city_id =1