Need to query against both tables data and show two results , source and target result

1

I want to query against these two table and exclude all matched rows and show two results, one result of 20thAug_table, second result of 30th Aug table, only unmatched rows.
I intentionally made first 3 rows same in both tables.
then my result has to be only bottom 4 rows from table 1 side and table 2 side., since they are not matching based on all columns values check.

result_cdc_AUG_20 has to be the following 4 rows:

select '0000237', 'UFX', '580', '2400 BARCLAY RD', '142110000' union all
select '0000238', 'KKR', '581', '5th RECORD ROAD', '142110005' union all
select '0000239', 'ELL', '579', '6th RECORD ROAD', '142110006' union all
select '0000240', 'BLL', '580', '7TH RECORD ROAD', '142110007'

result_cdc_AUG_30 has to be the following 4 rows:
select '0000237', 'UFX', '580', '4TH NOT MATCHED ROW', '77770000' union all
select '0000238', 'KKR', '581', '5th NOT Matched ROW', '142110000' union all
select '0000239', 'ELL', '579', '6th NOT MATCHED ROW', '142110000' union all
select '0000240', 'BLL', '580', '7TH NOT MATCHED ROW', '142110000'
Thank you for the helpful details thk U.

declare @Sample_cdc_AUG_20 (asset_num varchar(20), prod_cd varchar(20), addr_ln_1 varchar(100),zip_cd varchar(20))
insert @Sample_cdc_AUG_20
select '0000234', 'IPL', '579', '12 JULEL ROAD', '142110000' union all
select '0000235', 'KPL', '580', 'LYDA ROAD 22', '142110000' union all
select '0000236', 'NFL', '581', '19th Ave UNIT 2', '142110000' union all
select '0000237', 'UFX', '580', '2400 BARCLAY RD', '142110000' union all
select '0000238', 'KKR', '581', '5th RECORD ROAD', '142110005' union all
select '0000239', 'ELL', '579', '6th RECORD ROAD', '142110006' union all
select '0000240', 'BLL', '580', '7TH RECORD ROAD', '142110007' 


declare @Sample_cdc_AUG_30 (asset_num varchar(20), prod_cd varchar(20), addr_ln_1 varchar(100),zip_cd varchar(20))
insert @Sample_cdc_AUG_30
select '0000234', 'IPL', '579', '12 JULEL ROAD', '142110000' union all
select '0000235', 'KPL', '580', 'LYDA ROAD 22', '142110000' union all
select '0000236', 'NFL', '581', '19th Ave UNIT 2', '142110000' union all
select '0000237', 'UFX', '580', '4TH NOT MATCHED ROW', '77770000' union all
select '0000238', 'KKR', '581', '5th NOT Matched ROW', '142110000' union all
select '0000239', 'ELL', '579', '6th NOT MATCHED ROW', '142110000' union all
select '0000240', 'BLL', '580', '7TH NOT MATCHED ROW', '142110000'
2

Your code doesn't work, but generally you would do this:


SELECT *
FROM @Sample_cdc_AUG_20
EXCEPT
SELECT *
FROM @Sample_cdc_AUG_30

SELECT *
FROM @Sample_cdc_AUG_30
EXCEPT
SELECT *
FROM @Sample_cdc_AUG_20