insert into dlyatten (code, date, type, category, scode, lCode, sec,syear ) ; select code, m.pDate, 1, "P", scode, lCode, Sec,ssyear ; from Student st ; WHERE Admtd = 1 ; AND NOT EXISTS (SELECT * FROM dlyatten dl ; WHERE dl.code = st.code AND date=pdate )