>>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.
>
>I take it V1 is the orders table detail with an associated customer number. I suppose the query runs, but you're bringing up a larger set than you need to. Just run the custkey subquery by itself and you'll notice. The subquery should have the DISTINCT clause in it.
Really? I thought the DISTINCT clause in the subquery would just add overhead, rather than actually speeding up the main query.