SQL - compare tables and create another tables that are different
I would like to compare two tables A and B with the identical schema.
I try to compare if anything change and produce a table with the changes.
I use a query to query multiple tables and insert all the results into Table A for Day 1
I use the same query to query multiple tables and insert all the results into Table B on Day 2.
Then I would like to see what has changed in Table A by comparing with Table B and I would like to save the result into another Table same schema as Table A and Table B.