Re: collapse SELECT from multiple tables
| From: | John Nichel | Date: | Thu, 24 Mar 2005 19:03:23 +0000 |
| Subject: | Re: collapse SELECT from multiple tables | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-211495@lists.php.net to get a copy of this message | ||
Jay Blanchard wrote:
<snip>
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; </snip>I got zero results returned. ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 john@kegworks.com