>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.