Joining Two Tables and Creating Flag

[Vigneswaran]

Dears, 

I'm stuck in joining two tables with respect to common ID. After joining, i need to create one flag which gives the result of join (please refer to resultant screenshot). 

Table A
Transaction ID	Date	Amount
1122	1/1/2024	120
2233	2/2/2024	230
3344	3/3/2024	320

Table B
Transaction ID	Status	Date	Amount
1111	Pass	3/1/2024	90
1122	Fail	1/1/2024	120
3344	Pass	3/3/2024	320

Expected Result
Table A_Transaction ID	Table A_Amount	Table B_Transaction ID	Table B_Status	Table B_Amount	Flag
1122	120	1122	Fail	120	ID Available in both table
2233	230	-	-	-	ID Not avilable in Table B
3344	320	3344	Pass	320	ID Available in both table
-	-	1111	Pass	90	ID Not avilable in Table A

Kindly help on achieving this!

[nagakavyasri · Accepted solution]

@Vigneswaran 

[Vigneswaran]

Thanks a ton! Great one!