Sergey i think u gave me reply . I searched but could not find thread.
Now i want to use query into mysql SQLEXEC. How this possible
thanks

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 )