Actually, at second glance, I think you just need to combine the WHERE:
SELECT * FROM CUSTOMER ;
WHERE MAXORDAMT > 50000 AND ALLT(COUNTRY) = 'USA'
>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.