Use of left and right: select table1.column1, table1.column1 from table1 right join table2 on table1.column2 = table2.column2select a.aa, b.bb, c.ccfrom a left join b on A.ID1 = B.ID1 LEFT JOIN C on A.ID2 = C.ID2HTTP: //www-900.ibm.com/developerWorks/cn/dmdd/library/techarticles/0112purcell/0112purcell.shtml1 Prepatch A. Nested Table Expression; B .Where clause, rule of predicate before writing in the WHERE clause is that they must only apply only to the predicate when the connection is written. The predicate is written on the ON clause; the predicate in the ON clause or when connected The predicate does not limit the number of rows of returns; they can only be connected. Only the predicate of the WHERE clause limits the number of rows that truly retrieved. 3) Predicate after the connection
