>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 )
>

What seems to be a problem?