Compare 2 different tables having same columns and difference in data

[bhargavikn]

Hi team,

We have 2 different sources as below having same column names but difference in data.

T1:

ID	Reference	Price	Date
A1	1234	100	Jun-23
A2	2345	200	Jun-23
A3	3456	300	Jun-23
A4	4567	100	Jun-23

T2:

Reference	Price	Date
1234	100	Jun-23
2345	300	Jun-23
3456	200	Jun-23
5678	400	Jun-23

Need to create flags few below scenarios.

#	Need
1	Show only excess records of T1
2	Show only excess records of T2
3	If Reference is there in both and Price is different Flag those records
4	If Reference is there in T1 and missing in T2 or vise versa, Flag them with Table name

Could you please help me with your ideas.

Thank you!