JOIN Problem

[colep]

Can anyone tell me what is wrong with this Select Statement???

SELECT morning_show.page_header,first_dj.img AS img1,second_dj.img AS img2 FROM morning_show LEFT JOIN djs AS first_dj ON first_dj.id=morning_show.dj1_id LEFT JOIN djs AS second_dj ON second_dj.id=morning_show.dj2_id;

It is giving me this error: You have an error in your SQL syntax near 'ON first_dj.id=morning_show.dj1_id LEFT JOIN djs AS second_dj ON second_dj.id=mo' at line 1

I'd appreciate any help!!!!

Thanks,
Cole

 

[TonyGroves]

Can't see anything wrong there, unless it's objecting to the semicolon at the end, which is only accepted by some client interfaces.

-----
ALTER world DROP injustice, ADD peace;