Hi all,
I'm new to MySQL and am puzzled by a curious problem. This join syntax has
always worked fine for me on SQLServer but it seems to work like an inner
join on MySQL:
SELECT d.doccat_ID, d.doccatname
FROM doccats d LEFT OUTER JOIN doccat_group dg ON d.doccat_ID = dg.doccat_ID
WHERE dg.group_ID = (SomeValue)
ORDER BY doccatname
I've checked the documentation and cannot seem to find anything wrong with
my syntax. Any thoughts?
Thanks,
Eric
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php