Link two columns from different tables in Data Sources

Hi,

This sounds simple and I have looked around but I can't find an aswer - maybe becuase I am still starting.

I wanted to get the values from ColumnA into Column1 automatically. ColumnA and Column1 are in different tables.

So I basically wanted to mirror ColumnA from TableA to Column1 from Table1. 

I want to do this because TableA cannot be edited (DB connection) and I wanted to fiddle with the values and this way I could get the data on a different table and change it.

Thanks!

Ricardo