Home  |  Linux  | Mysql  | PHP  | XML
 
From:Yves Sucaet Date:Sat May 10 17:12:00 2008
Subject: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
>
>
Navigate in group php.db at sever news.php.net
Previous Next




  
© No Copyright
You are free to use Anything 		Site Maintained by PHP Developer
Powered By PHP Consultants