which one of these rooms has reservations?
SELECT * FROM rooms WHERE roomid IN  ( SELECT DISTINCT room FROM reservations ) 
rooms that have reservations refers to rooms with an entry in the reservations table; DISTINCT is used to ensure each room is listed once if it has one or more reservations;