Welcome to Vista Manor 3 BHK with pool 1 5 hrs from Mumbai , Manor , India
SELECT room_type.*,room.fld_roomtype AS fld_room,room_type.fld_id as rid FROM tbl_mghotel_roomstype AS room_type LEFT JOIN tbl_roomstype AS room on room_type.fld_roomtype=room.fld_id WHERE room_type.fld_hotelid = '76221'