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/en/JOIN.html > > > --- Osman Omar <[EMAIL PROTECTED]> 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/ > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
