Re: Get data from 5 tables
| From: | olinux | Date: | Thu, 06 Mar 2003 06:53:55 +0000 |
| Subject: | Re: Get data from 5 tables | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-138423@lists.php.net to get a copy of this message | ||
SELECT * FROM table1, table2, table3, table4
WHERE id = 1 AND
table1.id=table2.id AND
table2.id=table3.id AND
table3.id=table4.id AND
etc.
or you can use a JOIN
http://www.mysql.com/doc/en/JOIN.html
--- Osman Omar <osman@sem.my.sony.com.sg> wrote:
> Hi,
>
> How do I query to get data from 5 tables with same
> id. (id=1).
>
> eg,
>
> table1
> id data
> 1 blue
> 2 green
>
> table2
> id data
> 1 yellow
> 3 green
>
> table3
> id data
> 1 black
> 4 white
>
> etc.
>
> thanks
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/