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 ?
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