James,

The second WHERE should be an AND...

-Dan

>Can anyone tell me what's wrong with this sql statement:
>
>SELECT applicant_type ;
> FROM projects ;
> WHERE projects.applicant_type IN ;
> (SELECT applicant_type FROM curTypes) ;
> WHERE projects.projkey = liProjKey ;
> INTO CURSOR curApp_types