I have SQL statements with more files than this one. I have had the missing column thing come up when the first record did not satisfy all the join conditions.

>I'm getting some strange results in large SQL query involving several tables. I created my "joins" in the from/where clauses because of the limitation of 9 joins in VFP. Anyone know how many tables are allowed in the sql "from" clause? I get 'column ccityid not found' the first time I run this prg. The second time I run it, I don't get an error.
>
>SET SAFETY off
>SET EXCLUSIVE off
>lcDataLocation = 'F:\DEVELOP\edwin\data\'
>lcCommonDataLocation = 'F:\DEVELOP\edwin\data\CommonData\'
> SELECT ;
> student.CFIRSTNAME,;
> student.CFORMERNME,;
> student.CGENDER,;
> student.CGRADE,;
> student.CID,;
> student.CISBEID,;
> student.CLASTNAME,;
> student.CMEDICAID,;
> student.CMIDNAME,;
> student.CSITEID,;
> student.CSSN,;
> student.DDOB,;
> student.CC1ADDR1,;
> student.CC1ADDR2,;
> cc1city.ccity as cc1citynam,;
> student.CC1EMAIL,;
> student.CC1FFRST,;
> student.CC1FLAST,;
> student.CC1FSALUT,;
> student.CC1MFRST,;
> student.CC1MLAST,;
> student.CC1MSALUT,;
> student.CC1PHONE1,;
> student.CC1PHONE2,;
> student.CC1PHONE3,;
> lutcc1rel.cdescription as cc1relatio,;
> student.CC2ADDR1,;
> student.CC2ADDR2,;
> cc2city.ccity as cc2citynam,;
> student.CC2EMAIL,;
> student.CC2FFRST,;
> student.CC2FLAST,;
> student.CC2FSALUT,;
> student.CC2MFRST,;
> student.CC2MLAST,;
> student.CC2MSALUT,;
> student.CC2PHONE1,;
> student.CC2PHONE2,;
> student.CC2PHONE3,;
> lutcc2rel.cdescription as cc2relatio,;
> student.CC3ADDR1,;
> student.CC3ADDR2,;
> cc3city.ccity as cc3citynam,;
> student.CC3EMAIL,;
> student.CC3FFRST,;
> student.CC3FLAST,;
> student.CC3FSALUT,;
> student.CC3MFRST,;
> student.CC3MLAST,;
> student.CC3MSALUT,;
> student.CC3PHONE1,;
> student.CC3PHONE2,;
> student.CC3PHONE3,;
> lutcc3rel.cdescription as cc3relatio,;
> attecity.ccity as attendcity,;
> attescho.cattendname as attendschool,;
> homecity.ccity as homecity,;
> homescho.cattendname as homeschool,;
> student.CDCFSCASE,;
> student.CSPADDR1,;
> student.CSPADDR2,;
> student.CSPBUSPH,;
> student.CSPCITYID,;
> student.CSPFRSTNME,;
> student.CSPHOMEPH,;
> student.CSPLASTNME,;
> student.DDCFSUPDT,;
> student.DMEDUPDATE,;
> student.DSPAPPOINT,;
> student.LACTIVE,;
> student.LMEDAUTOUP,;
> student.MMEMO10,;
> student.MMEMO11,;
> student.MMEMO12,;
> student.MMEMO5,;
> student.MMEMO6,;
> student.MMEMO7,;
> student.MMEMO8,;
> student.MMEMO9;
> from;
> (lcDataLocation + 'student.dbf'),;
> (lcDataLocation + 'attend.dbf') as attescho,;
> (lcDataLocation + 'attend.dbf') as homescho,;
> (lcCommonDataLocation + 'city.dbf') as attecity,;
> (lcCommonDataLocation + 'city.dbf') as homecity,;
> (lcCommonDataLocation + 'city.dbf') as cc1city,;
> (lcCommonDataLocation + 'city.dbf') as cc2city,;
> (lcCommonDataLocation + 'city.dbf') as cc3city,;
> (lcCommonDataLocation + 'lut.dbf') as lutcc1rel,;
> (lcCommonDataLocation + 'lut.dbf') as lutcc2rel,;
> (lcCommonDataLocation + 'lut.dbf') as lutcc3rel;
> where;
> attescho.cid = student.catndschid;
> and attecity.cid = attend.ccityid;
> and cc1city.cid = student.cc1cityid;
> and cc2city.cid = student.cc2cityid;
> and cc3city.cid = student.cc3cityid;
> and homecity.cid = attend.ccityid;
> and homescho.cid = student.chomeschid;
> and lutcc1rel.cid = student.cc1relid;
> and lutcc2rel.cid = student.cc2relid;
> and lutcc3rel.cid = student.cc3relid;
> into table (lcDataLocation + 'ffsgen.dbf')