Hey everyone,
Can you help me with query that i can join with this table condition:
Table A:
|Name_Phone|
|A_0123123|
|B_0124124|
Table B:
|Name_Phone|ADRRESS|
|A_01230123|A|
|A_01230123|B|
|A_01230123|C|
|B_0124124|A|
|B_0124124|B|
and the result that i want is, i just want to join that always the last row of duplicate data, for example:
|Name_Phone|ADRRESS|
|A_01230123|C|
|B_0124124|B|
Need help