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
