Thank you Rich, your sample solved the problem.
>>These two lines run fine if I run one after the other.
>>
>>SELECT * FROM V1 WHERE MAXORDAMT > 50000
>>
>>SELECT * FROM CUSTOMER WHERE ALLT(COUNTRY) = 'USA'
>>
>>If I try to nest them, they don't run, what am I doing wrong?
>>SELECT * FROM CUSTOMER ;
>> WHERE MAXORDAMT > 50000 AND ;
>> (SELECT * FROM CUSTOMER WHERE ALLT(COUNTRY) = 'USA')
>
>If this posting has the correct table names in the first two SELECT commands, here's the syntax for the subquery:
SELECT * FROM CUSTOMER ;
> WHERE ALLT(COUNTRY) = 'USA' ;
> AND CustKey IN (SELECT CustKey FROM V1 WHERE MAXORDAMT > 50000)
>HTH,
>Rich.