copy data from a column in table a into a column in table b!

[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)

[fenway]

Why would you want to do such a thing?