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