Copy records

[ChewDoggie]

Hello,

I have a "results" table with the following fields:

eventid - KEY
racerid - KEY
racenum - KEY
amaclassid - KEY
classid - KEY
runclassid
racetype - KEY
fpos
runfpos
comp
DN
advflg

and it's filled with records for eventid "8". I want to copy all of eventid "8" to eventid "7", but eventid "7" does not yet exist in the table.

How do I do this?

Thanks!



AMACycle

American Motorcyclist Association

http://www.ama-cycle.org

 

[Crowley16]

insert into table
select 7, col1, col2...
from table
where eventID = 8



--------------------
Procrastinate Now!

 

[ChewDoggie]

Thank you! That worked perfectly.



AMACycle

American Motorcyclist Association

http://www.ama-cycle.org