Careful here, a left join is not necessarily the same as a join. In
particular a left join will return rows for the left table even if there are
no matching rows in the right table. Under many conditions the two are
identical but definitely not always. That being said, maybe one could use
temp tables? I see several issues in the change logs regarding left joins
but I do believe they were available for 3.22.32.
Good luck,
Jeff
-----Original Message-----
From: Tim [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 12:03 PM
To: Holger Bohnke
Cc: mysql
Subject: Re: LEFT JOIN in MySQL Version 3.22.32
this:
select tbl1.field1, tbl2.field2 from tbl1, tbl2 where tbl1.id = tbl2.id
is the same thing as:
select tbl1.field1, tbl2.field2 from tbl1 left join tbl2 on tbl1.id =
tbl2.id
- TIM
> Hi,
>
> unfortunately my provider still runs My SQL version 3.22.32 on his server.
> Apparently the LEFT JOIN statement does not work on this version.
>
> Anybody knows a workaround?
>
> Holger
>
>
> ---------------------------------------------------------------------
> 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
>
--
-TIM
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
