expression compare   [ NOT ] ALL ( subquery )

compare:
= | > | < | >= | <= | <> | != | !< | !>

UltraLite uses the specified comparison operator to compare the test value to each data value in the result set. If all the comparisons yield TRUE results, the ALL test returns TRUE.

• Subqueries and the ALL test
• Comparison operators

Find the order and customer IDs of those orders placed after all products of order #2001 were shipped.

SELECT ID, CustomerID
FROM SalesOrders
WHERE OrderDate > ALL (
 SELECT ShipDate
 FROM SalesOrderItems
 WHERE ID=2001);