Along with the formal inner join syntax Bastien pointed out, isn't doing "WHERE t1.id = t2.id AND t2.id = t3.id" the same thing?
select [table.field] from table1 t1, table2 t2, table3 t3 where t1.some_field = t2.some_field and t1.some_field = t3.some_field -TG ----- Original Message ----- From: Bastien Koert <[EMAIL PROTECTED]> To: Ron Piggott <[EMAIL PROTECTED]>, PHP DB Posts <php-db@lists.php.net> Date: Sun, 21 Oct 2007 09:41:21 -0400 Subject: RE: [PHP-DB] inner join > > 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: > [EMAIL PROTECTED]> To: php-db@lists.php.net> Date: Sun, 21 > Oct 2007 07:07:06 -0500> Subject: [PHP-DB] 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
