>>>>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? :-)
Or combine them with AND
--sb--