Home › Category: stackoverflow › Query using three tables, joining 2, counting records where 2 columns match from 3rd?
symbol, number, section number, building, room number, and capacity.
I have no idea what to do for this query. I originally thought creating a new table from courseoffering_of and location would help, but our teacher wants us to do this all in a single query. I tried an inner join but couldn't figure out how to use it in this situation.