Multiple Inner Joins

[wispas]

I have this SQL query at the moment:

 

SELECT * FROM city INNER JOIN packages ON packages.city_code = city.city_code WHERE city_id='$id';

 

I have another table i want to inner join called hotel.

Does anyone know how to add this into the SQL query above.

[fenway]

Just add yet another join.

[zeodragonzord]

You do the same thing, just add another INNER JOIN clause.

SELECT * FROM city 
INNER JOIN packages ON packages.city_code = city.city_code 
INNER JOIN hotel ON tableIAmJoiningOn.field = hotel.hotelField
WHERE city.city_id='$id';