hi,
i have two tables EMP fields>ENO,ENAME,JOB,SAL,ROLE_NO,
,EMP1 fields>ENO,ENAME,JOB,SAL,ROLE_NO,REMARKS

i want to insert a record to emp1 from emp table and additionally i want to add REMARKS

i have tried these querey

STRING REM='GOOD'
INSERT INTO EMP1(ENO,ENAME,JOB,SAL,ROLE_NO,REMARKS) SELECT ENO,ENAME,JOB,SAL,ROLE_NO FROM EMP,REM

BUT IT SHOWS ERROR
THERE IS ANY WAY TO INSERT A RECORD IN THIS MANNER

IF IT PLS HELP ME


THANKYOU

hi,

I used this sample query and tested,
insert into stud(sname,dept,mark) select sname,dept,'80' from stud2
Its working fine for me..

Try ur query like this,
INSERT INTO EMP1(ENO,ENAME,JOB,SAL,ROLE_NO,REMARKS) SELECT ENO,ENAME,JOB,SAL,ROLE_NO,'GOOD' FROM EMP.