Outer joins can also be specified for views and derived tables.
SELECT * FROM V LEFT OUTER JOIN A ON (V.x = A.x);
can be interpreted as follows:
Compute the view V.
Join all the rows from the computed view V with A by preserving all the rows from V, using the join condition
V.x = A.x.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|