比较两个查询和同步结果

I have a table (Rooms) which contains a number of rows. Each row represents a room and each room needs to exist twice (once for fall, once for spring semester). Sometimes when folks add a room they only add it for one semester. I'm working on a process that will synchronize the rooms between semesters.I have a table (Rooms) which contains a number