>Boris, in this sql , I want use where admtd=1 from student and type=1 from dly and pdate from public, When i put this in your codes no result i have found, How this fix.
>thans

O, I didn't notoce you have SET FILTER, try:

INSERT INTO dly (code,date, type, category, scode, lcode, sec);
SELECT Student.code,;  && This goes to Dly Code field
       pdate,;         && This goes to Dly Date field
       1,;             && This goes to Dly Type field
       [P],;           && This goes to Dly Category field
       Student.scode,; && This goes to Dly SCode field
       Student.lcode,; && This goes to Dly LCode field
       Student.sec;    && This goes to Dly Sec field
FROM Student;
LEFT JOIN Dly ON Student.Code = Dly.Code;
WHERE Dly.Code IS NULL AND Student.Admtd=1