Welcome to Private Apartment in RT nagar near Hebbal , Bangalore , 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 = '20646'