User UserID Name Adress bla... RoomID Room ... a Max x Room1 a Max y Room2 a Max z Room2 b Peter x Room1 b Peter y Room2 b Peter z Room3
UserID a Max b Peter
select * from User join Join_User_Room on UserID = UserID join Room on RoomID = RoomID where RoomID in( X, Y, Z)