MySQL Forums
Forum List  »  Newbie

Re: Difficulty framing a JOIN statement
Posted by: tony mount
Date: April 16, 2012 12:18AM

Thanks pb. I get a syntax error between the first JOIN and showid=.

What I have is a list of people, a list of shows and a list of roles (singer, producer, dancer etc etc) and another table which indicates which person is in which show with what role. What I want is a screen which, for a selected production, lists all the people and what role they have (if any). So I want every person, one show and what role if any a person has.

Options: ReplyQuote

Written By
Re: Difficulty framing a JOIN statement
April 16, 2012 12:18AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.