RE: [PHP-DB] inner join
| From: | TG | Date: | Sun, 21 Oct 2007 14:52:09 +0000 |
| Subject: | RE: [PHP-DB] inner join | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44245@lists.php.net to get a copy of this message | ||
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 <bastien_k@hotmail.com>
To: Ron Piggott <ron.piggott@actsministries.org>, 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:
> ron.piggott@actsministries.org> 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
>
>