Hello.
I'm looking for some help on a complicated query. I'm not sure I'm using the Joins correctly. I have data in 5 different tables I want displayed on this page. The query I have now is SELECT Shows.Season_RID, Shows.Show_Name, Shows.Show_RID, Season.Season_Name, cast.Role, production_team.Title FROM Season, osc1_company, Shows LEFT JOIN production_team ON Shows.Show_RID = production_team.Show_RID LEFT JOIN cast on Shows.Show_RID = cast.Show_RID WHERE osc1_company.First_Name='$fname' AND osc1_company.Last_Name='$lname' AND osc1_company.RID = cast.RID AND osc1_company.RID = production_team.RID AND Shows.Season_RID = Season.Season_RID ORDER BY Season.Season_RID This works, but only if a title and a role exists for the company member. Basically, I want to display the season name from tbl Season, then the show title from tbl Shows, then the roles from cast and titles from production_team for the company member. The table Season has Season_Name and Season_RID. The table Shows has Season_RID, Show_RID, and Show_Name. osc1_company has First_Name, Last_Name, and RID. Cast has RID, Role, Show_RID. Production_team has RID, title, Show_RID. Any help folks could give would be hugely appreciated. Been working on this for quite a while now. Thanks Ron