RE: [PHP] collapse SELECT from multiple tables
| From: | Jay Blanchard | Date: | Thu, 24 Mar 2005 18:48:14 +0000 |
| Subject: | RE: [PHP] collapse SELECT from multiple tables | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-211492@lists.php.net to get a copy of this message | ||
[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;