Move Info From One Table To Another Using SQL

[greysquirl]

I need some help using SQL. I have two tables, Review & PositionChg. What I want to do here is take two columns of information from Review (position and position start) and move them to the positionchg table under (position & datechg).

Review PositionChg
Department - - - - - - ->Department
Position - - - - - - - ->Position
Position Start - - - - ->DateChg

I have the rest figured out, but just in case it might help. What should happen here is when an employee makes a position change the information about thier old job will be stored in another table. In a nutshell. . . . .

 

[gwinn7]

I am assuming we are talking about an Append Query and not Update, correct? Here is an example:

"INSERT INTO PositionChg( Department, DateChg)
SELECT Review.Department, Review.[Position Start]
FROM Review;"

Hope this helps.

Gary
gwinn7