Joins without join expression

In SESAM/SQL, an inner join or a cross join can also be created without a join expression. The tables to be joined are listed in the FROM clause of a SELECT expression, and the join search condition is formulated in the corresponding WHERE clause.

---

SELECT ... FROM table_specification , table_specification [,...] WHERE search_condition_with_join_column

---

Example

Select customer names and the associated order numbers from the CUSTOMERS and ORDERS tables:

SELECT company, order_num FROM customers, orders WHERE customers.cust_num= orders.cust_num