In a Mapping, you can easily consult all the potential results returned by a join condition, when its execution location is set on "Source".

  • Right click on the join
  • Choose Action
  • Select the operation you want to perform

 

1.mappingExample

This will generate the corresponding request in the Stambia Query Editor:

SLQ01

 

You can also perform this on multiple joins. Simply select multiple joins with the 'Ctrl' key before right clicking on one of them:

3.multipleJoins