Previous Topic Next topic Print topic

Micro Focus Enterprise Test Server 2.3 Update 1 > Data Access > Database Access > SQL Option for DB2 > Reference > SQL Reference > Clauses > WHERE Clause Syntax and Description > Joins

Joins

A join is a form of query that occurs any time more than one table or view name appears in the FROM clause of a query statement -- resulting in column data being retrieved from each table. The XDB Server allows up to 10 table names to appear within each level of a query.

More:

Parent topic: WHERE Clause Syntax and Description
Previous Topic Next topic Print topic