Hello.
I'm looking for some help on a complicated query. I have data in 5 different tables I want displayed on this page. The query I have now is $query = "SELECT Shows.Season_RID AS SEASON_NUM, Shows.Show_Name AS NAME, Shows.Show_RID AS SHOWX, Season.Season_Name AS SEASON, cast.Role AS CAST, production_team.Title AS TITLE FROM osc1_company, production_team, Season, Shows, cast 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 production_team.Show_RID=Shows.Show_RID AND Shows.Season_RID = Season.Season_RID AND Shows.Show_RID = cast.Show_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