From: Martijn Tonies
Date: November 20 2003 3:11pm
Subject: Re: [SOLVED]Re: LEFT JOIN problem
List-Archive: http://lists.mysql.com/mysql/154224
Message-Id: <059701c3af78$83c6b540$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit




> * Martijn Tonies
> > * Rory McKinley
> > > Thanks Roger
> > >
> > > That fixed the problem.....I was under the impression that I only had
to
> > > put the linked columns n the ON and everything else in the
WHERE....live
> > > an learn I guess.
> >
> > Ehm, I'm not completely sure, but isn't this invalid behaviour?
>
> Huh? What would be invalid about it?

That moving parts of the WHERE clause to the JOIN clause returns
a different result set. But as I said: I don't have the full story ... oh
wait,
I found the first message in my mailbox somewhere.

I guess "OUTER" is optional, and INNER is default - right?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com