Joining three tables 1

Evil8 · Oct 28, 2010

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 · Oct 28, 2010

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 · Oct 28, 2010

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Joining three tables 1

Evil8

MIS

PHV

MIS

Evil8

MIS

Similar threads

Part and Inventory Search

Sponsor