RE: collapse SELECT from multiple tables

["Jay Blanchard" <jay.blanchard@xxxxxxxxxxxxxxxxxxxxx>]

[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