| Multiple Insert, Internal Query and Static Value [message #244432] |
Tue, 12 June 2007 15:08  |
hdogg
Messages: 94
Registered: March 2007
|
Member |
|
|
I am doing an insert statement, copying one table to another while adding a "ARCHIVE ID"
INSERT INTO Employee_ARCHIVE(First_Name,Last_Name, ARCHIVEID)
SELECT First_Name, Last_Name FROM EMPLOYEES , $archiveid????
Archive ID is a static number, that is the same for the whole batch
So the question is, how can do i select and copy some values from another table, while also inserting some static values?
[Updated on: Tue, 12 June 2007 15:14] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
