Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Copy a customer account
- Thread starter mnassih
- Start date
INSERT INTO Customers
(...fieldlist...)
SELECT [same fieldlist, same order]
FROM Customers
WHERE ID = [the ID of the current record]
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.
(...fieldlist...)
SELECT [same fieldlist, same order]
FROM Customers
WHERE ID = [the ID of the current record]
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.
- Status
Similar threads
- Locked
- Question