Welcome to Happy Camper Comfortable and Peaceful Place 1 RK 101 , Mysore , 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 = '41226'