meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
sap_hybris_commerce:import_export:examples-of-flexible-search-queries [2020/06/29 11:51] – left outer join Antonio Robirosasap_hybris_commerce:import_export:examples-of-flexible-search-queries [2020/06/29 12:03] (current) – [Outer joins] Antonio Robirosa
Line 45: Line 45:
 FROM {PointOfService as p FROM {PointOfService as p
 LEFT OUTER JOIN Address as a LEFT OUTER JOIN Address as a
-  ON {p.address} = {a.pk} +  ON {p.address} = {a.pk}}
-  AND {a.modifiedtime} >= '2020-10-01'}+
 WHERE {p.modifiedtime} >= '2020-10-01' WHERE {p.modifiedtime} >= '2020-10-01'
-ORDER BY {p.baseStore}, {creationtime} DESC+  OR {a.modifiedtime} >= '2020-10-01' 
 +ORDER BY {p.baseStore}, {p.creationtime} DESC
 </code> </code>