SELECT g.rid, room_no, planed_count,cc FROM
(SELECT rid,room_no, planed_count FROM YC_HOTEL_ROOM_T ) r
left join
(SELECT rid,count(*) cc FROM YC_GUEST_INFO_T group by rid ) g
ON r.rid = g.rid WHERE planed_count<>cc
SELECT g.rid, room_no, planed_count,cc FROM
(SELECT rid,room_no, planed_count FROM YC_HOTEL_ROOM_T ) r
left join
(SELECT rid,count(*) cc FROM YC_GUEST_INFO_T group by rid ) g
ON r.rid = g.rid WHERE planed_count<>cc