copy data from a column in table a into a column in tab

[jcrensha627]

I have a column called price in table a. and a column called price in table b - I am trying to figure how to make the column in table b be populated by the column in table a.

EXAMPLE

TABLE A TABLE B

price price
=== ===
50 (here i want the 50 from table a to appear automatically)

[coopster]

Why? If they have a common key relationship, why store the data twice?