[snip] I'm trying to figure out the best way to handle a SELECT from multiple tables where a single ID in tableA relates to multiple ID's in tableB:
"SELECT tableA.ID, tableB.data FROM tableA, tableB WHERE tableA.ID=3 AND tableA.ID=tableB.tableAID" What I'm trying to product is an array output similar to: | ID | data | | 3 | data1, data2, data3 | [/snip] SELECT a.foo, b.foobar FROM tableA a LEFT OUTER JOIN tableB b ON(a.id = b.id) SELECT p.users FROM php.list p LEFT OUTER JOIN mysql.list m ON (p.phpuserid = m.mysqluserid) GROUP BY p.users HAVING clue > 0; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
