Page 1 of 1

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

Posted: Sat Feb 28, 2009 6:18 pm
by 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)

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

Posted: Thu Mar 19, 2009 2:37 am
by jaoudestudios
So are you saying everytime something is inserted into tableA.price you want it to be automatically inserted into tableB.price?

There are a few ways you can do it, it depends on a few things.