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