Outer Joins

By default, the SQL repository uses outer joins in queries that involve auxiliary tables. Different database vendors use different syntax to create outer joins. The Oracle ATG Web Commerce platform automatically sets the outerJoinSupport property of the GSARepository component to specify the appropriate type of outer join to be used by the SQL repository. You can also configure this property manually, using the following values:

Value

Database Vendor

Description

sql92

Use FROM tablex x LEFT OUTER JOIN tabley y ON x.id = y.id

jdbc

Similar to sql92 but uses JDBC escape syntax {oj ... } to tell the JDBC driver to convert to native join syntax.

plus-equals

Oracle

x += y

star-equals

Microsoft

x =* y

informix

Informix

FROM OUTER tablex

none

Use inner joins rather than outer joins.

Copyright © 1997, 2014 Oracle and/or its affiliates. All rights reserved. Legal Notices