Hi.
On Mon, Mar 19, 2001 at 02:40:43PM -0500, [EMAIL PROTECTED] wrote:
> 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?
The syntax is right for an outer join.
How about posting an example, too? :-)
Bye,
Benjamin.
---------------------------------------------------------------------
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