Wrong list. Putting "$sql=..." in there doesn't make it a PHP question. ;-)
Skip Evans wrote:
Is that what the left/right joins do???
Yea. LEFT JOIN will give you NULL entries in the left joined table, so
you'd just have to say WHERE ISNULL(<left joined table>.<some field in
that table>). Of course, you'll need to do the right JOINs in there for
that to work.
Personally, I think that implicit joins are sloppy, so I would suggest
using JOIN with ON or USING...but I suppose that's a preference thing,
and some (all?) might disagree with me.
jon
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
