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)
copy data from a column in table a into a column in table b!
Moderator: General Moderators
-
jcrensha627
- Forum Newbie
- Posts: 15
- Joined: Fri Feb 27, 2009 11:34 pm
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: copy data from a column in table a into a column in table b!
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.
There are a few ways you can do it, it depends on a few things.