meta data for this page
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
sap_hybris_commerce:import_export:examples-of-flexible-search-queries [2020/06/29 11:51] – left outer join Antonio Robirosa | sap_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} >= ' | + | |
WHERE {p.modifiedtime} >= ' | WHERE {p.modifiedtime} >= ' | ||
- | ORDER BY {p.baseStore}, | + | OR {a.modifiedtime} >= ' |
+ | ORDER BY {p.baseStore}, | ||
</ | </ | ||