Joining three tables
Joining three tables
(OP)
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!
$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!
RE: Joining three tables
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: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: Joining three tables