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)
INSERT INTO TABLE2 (ECNO, ERNO, ENAME) Select 1, ERNO, ENAME from TABLE1
update + select
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)