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)

[NogDog]

I don't think we have enough information here to provide an answer. How are the two tables related? In fact, from a database normalization viewpoint, maybe the first question should be, why do you want to store the same data in two different tables?