How to join 2 query to create a LEFT OUTER JOIN ?

[sanchoniathon]

Hello,

By the way, i'm trying to create a LEFT OUTER JOIN while joining 2 different queries and not sure how and what to include in my filters.

Any valuable examples to provide ?

[bvk.cognoise]

Hi Sanchoniathon.

First you create your base queries with required query items make sure you are maintaining one key column between two queries which allows you to create a join

For Eg: Order Query with Order Number , Delivered Query with Order Number

then go to query explorer then drag Join from  left side insertable object pane .Now drag Order Query over first doted line of Join,then drag Delivered Query over second dotted line of join.

Now double click on join Symbol specify cardinality  as specified below

Order Query Side 1:n -Delivered Query Side 0:N

PFA screenshot for more information.

Regards
Bvk