which one of these rooms has reservations?
select * from rooms where roomid in ( select distinct room from reservations )
What about the rooms which do not have reservations?
select * from rooms where roomid not in ( select distinct room from reservations )