Welcome to Fortune Home Service Apartment 4Bhk J 191 Saket , New Delhi , 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 = '8141'