SQL conditions are used:
•In WHERE and HAVING clauses in queries and subqueries.
•In ON clauses in join constructs.
USoft supports all industry-standard SQL condition constructs. These syntax options are an integral part of the standard SQL language. There are no USoft extensions in this area.
The syntax of sql-operator constructs is not detailed above. These constructs are all different: LIKE calls for a wildcard pattern and has an optional ESCAPE clause, IN calls for an enumeration, EXISTS for a subquery, and BETWEEN for two column expressions connected by AND, while IS NULL is an operator for comparing a value with the NULL value. See SQL operators for details.
This condition matches ARISTO products with an ID not higher than 6000 produced after February 1, 2022:
This condition matches ARISTO products except all ARISTO products from Australia and except all ARISTO products of type Consumer:
This conditions matches all tours to Brazil that do not have a guide: