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 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

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, > > u

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