Joining three tables 1

[Evil8]

Okay I am learning and I got two tables joined in a mysql database and working on a php page...

$query = 'SELECT * FROM `meeting` INNER JOIN `place` ON meeting.name = place.name'
. ' ORDER BY `state`,`city` ';

Now what is the correct syntax to join a 3rd table `information`? The meeting.info_id = information.id.

Any and all help is always appreciated. Thanks!

 

[PHV]

SELECT *
FROM meeting
INNER JOIN place ON meeting.name = place.name
INNER JOIN information ON meeting.info_id = information.id
ORDER BY state, city

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Evil8]

Thanks! That was too easy. The initial source I tried was incorrect and only confussed me.