From a beginner - SQL question

[Jimreaper]

PRIMARY KEY COL1 COL2
1 a
2 a
3 b
4 c
5 b
6 c
7 a
8 a


Question:
What is the correct syntax to use if I want to copy COL1 to COL2?

Thanks
I know this is an easy one I'm new to this.

 

[jebry]

Hi!

The SQL you need is:

UPDATE YourTable SET YourTable.col2 = [YourTable]![col1];

hth
Jeff Bridgham
bridgham@purdue.edu

 

[Jimreaper]

Thank you Jeff.