Home > Archive > MySQL Server Forum > November 2005 > Re: I need help with selecting from 2 identical tables in 2 separate









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: I need help with selecting from 2 identical tables in 2 separate
Bill Karwin

2005-11-18, 8:23 pm

phillip.s.powell@gmail.com wrote:
> Produced a syntax error on the LEFT INNER JOIN clause in MySQL 4.0.17.
> Sorry, no access to MySQL 4.1 :(

There's no such thing as a LEFT INNER JOIN.
The LEFT and RIGHT keywords apply only to OUTER JOINs.

Regards,
Bill K.
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com