Follwing query I have used for that. But it doesn't work <pre>INSERT INTO TABLE2 (ECNO, ERNO, ENAME) values (1, select ERNO, ENAME from TABLE1)
update + select
INSERT INTO TABLE2 (ECNO, ERNO, ENAME) Select 1, ERNO, ENAME from TABLE1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)