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 :
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
In fact it's easier in my script to use inner join as Gerald
suggested. Many thanks for your patience though.
Highway 57 Web Development -- http://highway57.co.uk/
I think I think; therefore I think I am.
-- Ambrose Bierce