>The following code produces an error in VFP6, but not in VFP5:
>
>SELECT submits.specno+"-"+submits.submno AS Index, LEFT(submits.descript,50) AS Description,;
> 0 AS statusno, {} AS datercvd;
> FROM submits ;
> WHERE Submits.ProjNo = mbhProjNo;
> AND Submits.ProjNo+Submits.SpecNo+'-'+Submits.Submno
NOT IN ;
> (SELECT History.ProjectNo + History.SubmitNo FROM History) ;> ORDER BY 1, 4;
> GROUP BY 1;
> INTO CURSOR step1
>
>It appears to be coming from the 'NOT IN' section which should be highlighted above. Is there something new in SQL which is tripping me up?
>
>TIA
Michael,
What error does it produce?