Jump to content
TNG Community
Sign in to follow this  
KevyNC

SQL / Report code

Recommended Posts

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

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×