>Did you try combining the WHERE, as in my other message?
>
>
>SELECT * FROM CUSTOMER ;
> WHERE MAXORDAMT > 50000 AND ALLT(COUNTRY) = 'USA'
>
>
>Mark

Marks making a good point, his method will work, and be more efficient than a subquery, if MaxOrdAmt and Country are both fields in the Customer table.

From one of your posts, I got the impression that the table with MaxOrdAmt was called V1. If you're selecting records from one table based on their fitting with a subset of records from another table, you will need a subquery. If Customer is the only table your queries are dealing with, Mark's answer is best.

Cheers,
Rich.