Appendix : Legacy Presto components : Mashables and Mashups : Mashups in EMML : Advanced Mashup Techniques : Using XQuery for Outer Joins
Using XQuery for Outer Joins
 
Sample Mashable Results
Constructing the Join
The <join> command in EMML works like an inner join for SQL - only items that have values that match the join condition are selected. For outer joins, you want to see all items from one set of results and join this with other results even if there is no matching result.
You can get the affect of an outer join using XQuery and the <constructor> statement to build the join results.
Copyright © 2013-2017 Software AG, Darmstadt, Germany. (Innovation Release)

Product LogoContact Support   |   Community   |   Feedback