select [table.field] from table1 t1 inner join table2 on t1.some_field = t2.some_field inner join table3 t3 on t1.some_field = t3.some_field where [clauses as needed] bastien ----------------------------------------> From: ron.piggott@xxxxxxxxxxxxxxxxxx> To: php-db@xxxxxxxxxxxxx> Date: Sun, 21 Oct 2007 07:07:06 -0500> Subject: inner join>> Can you inner join 3 tables together? Do you know what the syntax would be?> Ron>> --> PHP Database Mailing List (http://www.php.net/)> To unsubscribe, visit: http://www.php.net/unsub.php> _________________________________________________________________ Are you ready for Windows Live Messenger Beta 8.5 ? Get the latest for free today! http://entertainment.sympatico.msn.ca/WindowsLiveMessenger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
