>>>James,
>>>
>>>You have 2 WHERE clauses in one query.
>>>
>>>>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
>>
>>Or is it that the parenth. should be around the rest of the second select, ie after the 2nd WHERE?
>
>No, the fields in both WHERE clauses belong to the main query table.

Ah yes. Well he aught to decide WHICH where is important then, eh? :-)