To keep those similiar column names apart and more readable, you might want
to use AS.
SELECT table1.data AS data1, table2.data AS data2 ... FROM table1, table2
...
Of course this is optional, you can always use table1.data, table2.data
instead. Hope that answers your actual question as to how yo
ok,
how do I know which data come from which table?
On Wed, 5 Mar 2003, olinux wrote:
> 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/
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 <[EMAIL PROTECTED]> wrote:
> Hi,
>
> How do I query to get data from 5 tables wi
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.
4 matches
Mail list logo
