Christian Hammers wrote:
>
> On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
> > He is doing an inner join, you are doing a left join, they (potentialy)
> > do not produce the same results.
> Hmm have to think about it... inner means fields where the right table has
> a NULL value in the condition are left out, right?
>
OOPS I didn't notice you said LEFT OUT, yes you have it right, inner join
will return only lines that exist in both tables, sorry for the earlier confusion.
---------------------------------------------------------------------
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
