I have three tables:

1. users

2. classrooms

3. classroom_users

I need a query that, given a user_id, can get all the data for all the classrooms that particular user is in. So, if I ran the query on the tables above given a user_id of 1, I want to get back the following result:

Thanks in advance for your help. I have been trying to wrap my mind around this SQL query for far too long.

FYI, I am using Postgres.

CodePudding user response：

This should help

select c.* from classroom_users cu, classrooms c
where cu.user_id = <input user id> and cu.classroom_id = c.id;