transstates
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, this is actually very straightforward. Please give the table definition, and I'll work out the SQL for you.
ASKER
Right on!
Thanks. That did it!
Jim
Thanks. That did it!
Jim