>when i run this query, visual fox pro closes.
>

>        INSERT INTO staffexam (sno,code,descr,lcode,sec,subcode,subcode,subject,pno,room,;
>        scode,syear,total,pass,sap,exam_month) SELECT sno,code,descr,lcode,sec,subcode,subcode,subject,pno,room,;
>        scode,syear,total,pass,sap,exam_month FROM ghii

Khubaib,

How did you manage to have two fields with the same name? (SubCode)

Is it VFP table or some other database?