Link to home
Create AccountLog in
Avatar of transstates
transstatesFlag for United States of America

asked on

Copying a record from Table1 To Table1

Hello All,

What I'm wanting to do is copy a record from table1 then copy it back to table1 with a new partnumber.  Part Number is a key field.

Question:  Is there a way to do this using a sql statement.

Thanks in advance!

Jim
ASKER CERTIFIED SOLUTION
Avatar of Carl Tawn
Carl Tawn
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of DEVLitehouse
DEVLitehouse

Yes, this is actually very straightforward. Please give the table definition, and I'll work out the SQL for you.
Avatar of transstates

ASKER

Right on!  

Thanks.  That did it!

Jim