>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

Your subquery syntax is incorrect. First of all, after the AND in your where clause, and before the subquery, you need V1.< field > [NOT] IN. Secondly, your subquery should only return one column, the Customer field which matches the field in V1.

HTH,
Rich.