Re: Inner joining 3 tables

select * from table1 inner join table2 on (table1.common1 = table2.common2) inner join table3 on (table2.common2 = table3.common3) HTH, Yves ----- Original Message ----- From: "Ron Piggott" <ron.php@actsministries.org> To: "PHP DB" <php-db@lists.php.net> Sent: Saturday, May 10, 2008 4:33 PM Subject: [PHP-DB] Inner joining 3 tables

How do I inner join 3 tables together? What would the syntax look like for this situation: Table 1 and table 2 have a common field; Table 2 and table 3 have a common field Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php