I am using 3 tables where group by id has to be implemented on first to tables and not on 3rd table since the columns are different in 3rd table but i should get the complete combination as one result set
Table1
Id Name CreatedOn SpentAmt
1 abc 2023/03/31 1000
2 Test 2023/03/31 14000
3 Mark 2023/03/31 2000
4 Robert 2023/03/31 700
Table2
Id Name CreatedOn UsedAmt
1 abc 2023/04/01 2000
7 Grace 2023/03/23 4000
2 Test 2023/03/15 10000
9 Mary 2023/03/10 1000
Expected OutPut
Id Name SpentAmt UsedAmt
1 abc 1000 2000
2 Test 14000 10000
3 Mark 2000 Null
4 Robert 700 Null
7 Grace Null 4000
9 Mary Null 1000