It seems as though I have been building this website for ages and I am going insane. I have three tables (relevent fields are listed).
schools: has a field called ID, and School_Name
events: has a field called ID, GroupType, and School_ID (ID from schools table)
scores: has a field called ID, Event_ID (ID from events table) , season, and other fields which I dont think are necessary to talk about.
I am trying to get the rows from the scores table where the season = 0506. I also need to grab the School_Name as well. I know its simple but I cant get it. Can any one help?
