SQL / Report code

[KevyNC]

Can someone tell me what is wrong with the code below?  I had to have the processed killed on my server. ( I also tried wihout the order statement)

SELECT path, description, mediatypeID AS Media_type, p.personID, p.lastname, p.firstname, p.living, p.gedcom FROM tng_media AS m LEFT JOIN tng_medialinks AS ml ON (ml.mediaID=m.mediaID AND ml.gedcom=m.gedcom) LEFT JOIN tng_people AS p ON (ml.personID=p.personID AND ml.gedcom=p.gedcom) order by p.lastname, p.firstname

thanks, Kevin