Re: [PHP] Help wtih a query?

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
.

Relevant Pages