SELECT THEN INSERT FROM TABLE1 TO TABLE2 THEN UPDATE A FIELD FROM TABLE 1 WHEN THAT DATA IS INSERTED [closed]

SELECT THEN INSERT FROM TABLE1 TO TABLE2 THEN UPDATE A FIELD FROM TABLE 1
WHEN THAT DATA IS INSERTED [closed]

References

Reference NO 1

http://stackoverflow.com/questions/15193454/select-then-insert-from-table1-to-table2-then-update-a-field-from-table-1-when-t

Reference NO 2

http://stackoverflow.com/questions/11763052/insert-or-replace-into-table2-from-table1

Reference NO 3

http://social.msdn.microsoft.com/Forums/office/en-US/68d8226c-cdcc-486b-b7d2-bf7202aa040a/action?threadDisplayName=inserting-rows-from-one-table-to-another-another-with-pk-column-value-incrementing-in-ms-access

Reference NO 4

https://forums.oracle.com/thread/2539569

Reference NO 5

http://www.bigresource.com/MS_SQL-Get-the-id-of-inserted-rows-gt-insert-into-table1-select-from-table-2--XfjZk9u8.html

Reference NO 6

http://dba.stackexchange.com/questions/34056/how-to-insert-data-from-one-table-to-another

Reference NO 7

http://www.dreamincode.net/forums/topic/290304-insert-into-table1-from-table2/

Reference NO 8

http://forums.asp.net/t/prev/1700497