Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Joins: Retrieving Data from Several Tables » Explicit join conditions (the ON clause)

Generated joins and the ON clause Next Page

Types of explicit join conditions

Most join conditions are based on equality, and so are called equijoins. For example,

FROM Departments JOIN Employees
   ON Departments.DepartmentID = Employees.DepartmentID;

However, you do not have to use equality (=) in a join condition. You can use any search condition, such as conditions containing LIKE, SOUNDEX, BETWEEN, > (greater than), and != (not equal to).


The following example answers the question: For which products has someone ordered more than the quantity in stock?

FROM Products JOIN SalesOrderItems
ON Products.ID = SalesOrderItems.ProductID
   AND SalesOrderItems.Quantity > Products.Quantity;

For more information about search conditions, see Search conditions.