Did you try combining the WHERE, as in my other message?
SELECT * FROM CUSTOMER ;
WHERE MAXORDAMT > 50000 AND ALLT(COUNTRY) = 'USA'
Mark
>I try the UNION clause and I get an error:
>"SELECT's are not union compatible"
>
>
>>I think you need the UNION clause:
>>
>>
>>SELECT * FROM CUSTOMER ;
>> WHERE MAXORDAMT > 50000 UNION ;
>> (SELECT * FROM CUSTOMER WHERE ALLT(COUNTRY) = 'USA')
>>>>
>>HTH!
>>Mark
>>
>>>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')
>>>
>>>
>>>Thank you in advance
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.