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 Column...