>>>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? :-)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.