SELECT h.hNo, h.hName, h.city
From Hotel as h
Inner Join Room as r
on h.hNo = r.hNo;
