Today I have the task of comparing data from two tables, this has been the process so far.
Write SQL Select for data source
Write SQL Select for data target
So I have two tables, table A and Table B.
They have the same amount of columns but they have different names (at this point).
What technique is recommended for this process of collecting records which match?