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