Wednesday, February 9, 2011

How to copy columns from one table into another table

Example:

INSERT INTO staff( firstName, lastName, address, homePhone, cellPhone, latitude, longitude )
SELECT firstName, lastName, address, homePhone, cellPhone, latitude, longitude
FROM gfxContact

No comments:

Post a Comment