Re: LEFT JOIN in MySQL Version 3.22.32

2001-06-12 Thread Holger Böhnke
? I see several issues in the change logs regarding left joins but I do believe they were available for 3.22.32. I use 3.22.32 on WinNT. Left Join works perfectly (I have one stmt that has 10 left joins). Yes, it does work! Actually it was the INNER JOIN that got me on the wrong track:

Re: LEFT JOIN in MySQL Version 3.22.32

2001-06-11 Thread Tim
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

RE: LEFT JOIN in MySQL Version 3.22.32

2001-06-11 Thread John Correa
Hello, I use 3.22.32 on WinNT. Left Join works perfectly (I have one stmt that has 10 left joins). JohnC -Original Message- From: Holger Böhnke [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 7:44 AM To: mysql Subject: LEFT JOIN in MySQL Version 3.22.32 Hi,

RE: LEFT JOIN in MySQL Version 3.22.32

2001-06-11 Thread Jeff Brewer
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