I created a cursor and trying to apply it to a select staement.

select all a.cid, a.cname, b.csemester, b.ccourse, b.ccouroff, b.cstudent from sys_mast a, enroll b where alltrim(a.cname) in (select alltrim(sem_Names) from SQL_Sem) into dbf c:\attend\temp

after I run this, I get all the values to the temp table, but cid, cname fields are empty.

I have spent a lot of time for this, I am going crazy.
Why am I not getting cid, cname field values?

I got so many reply for my previous questions and you guys have been very helpful. I appreciated it.