expression compare  [ NOT ] ANY ( subquery )

expression = ANY ( subquery )

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

UltraLite uses the specified comparison operator to compare the test value to each data value in the column. If any of the comparisons yields a TRUE result, the ANY test returns TRUE.

• Subqueries and the ANY test
• Comparison operators

Find the order and customer IDs of those orders placed after the first product of the order #2005 was shipped.

SELECT ID, CustomerID
FROM SalesOrders
WHERE OrderDate > ANY (
 SELECT ShipDate
 FROM SalesOrderItems
 WHERE ID=2005);