>>Now i want to convert into mysql query. these working fine in dbf
>
>Try
>

>TEXT TO lcSql TEXTMERGE NOSHOW PRETEXT 15
>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 dl.date= st.date )
>ENDTEXT
>

Sorry it is not working may be records from select is not supported .