8 messages in com.mysql.lists.mysqlRe: Stumped again by joins
FromSent OnAttachments
Chris Sansom25 Apr 2006 06:23 
Barry25 Apr 2006 06:55 
Chris Sansom25 Apr 2006 07:16 
Chris Sansom25 Apr 2006 08:44 
gerald_clark25 Apr 2006 09:10 
Philippe Poelvoorde25 Apr 2006 09:15 
Chris Sansom25 Apr 2006 10:08 
Peter Brawley25 Apr 2006 13:34 
Subject:Re: Stumped again by joins
From:Chris Sansom (chr@highway57.co.uk)
Date:04/25/2006 10:08:52 AM
List:com.mysql.lists.mysql

At 11:10 -0500 25/4/06, gerald_clark wrote:

Yes. 3.23 was not correct in the order of precedence. This has been answered many times here.

Sorry - I haven't been on the list all that long.

You need to change your comma join to an inner join.

Lovely! That's it - many thanks.

At 17:15 +0100 25/4/06, Philippe Poelvoorde wrote:

in 5.0.12 comma precedence was changed : http://dev.mysql.com/doc/refman/5.0/en/news-5-0-12.html

I did look at this but, my understanding of joins still being somewhat shaky, I didn't take in its full implications.

so try with parenthesis, your implicit join and left join should then works correctly.

In fact it's easier in my script to use inner join as Gerald suggested. Many thanks for your patience though.

-- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/

I think I think; therefore I think I am. -- Ambrose Bierce