Query with 2 joins

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, Show

Complicated Query

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 A