sascoms

hello,
i have an sql sentence which was working on mysql 4.
SELECT p.*, e.title, u.user FROM photos p, records e
LEFT JOIN users u ON u.user=p.user
WHERE p.approved=1 AND e.id=p.id

but this sql sentence now gives error on mysql 5.
it says: Unknown column 'p.user' in 'on clause'
however there is a column named user on p table.

does anybody have any idea what might be causing the this?
thanks in advance

__________________
server: pass40

sascoms

some google search with the error sentence gave the correct result here:
MySQL Bugs: #13551: #1054 - Unknown column 'xxxx' in 'on clause'

we need to put paranthesis around from tables and join expressions:
like below:
... FROM (table1, table2)
join ... ON (col1=col2)

incase anyone comes accross the same error.

__________________
server: pass40

~ K ~

Thank you very much, sascoms! Of all the pages I read on fixing the "joins" syntax error, your simple explanation is how I found my way!

__________________
Pass64: