I have two tables with exactly same schema. One is a week old and other is current. Let new record be new\_data and the old be old\_data. Both have a column called opportunity\_id which is the primary key, sales stages(1,2,3,4..etc) and sales\_values. Now in a week a sales stage may change for an opportunity or sales values of an opportunity may change. Even a new Opportunity\_id may be added. I need all the data that has changed.

I am trying INNER\_JOIN but that only works when opportunity\_ids match.I need newly added opportunities also.

I am using MS Access, so please provide only sql solution.

Thanks