Hello 

You can refer to the below documentation for better understanding on joins in outsystems.

https://success.outsystems.com/documentation/11/reference/outsystems_language/data/handling_data/queries/supported_join_types/

Hope that helps

Regards

Anees

•    Use “with” when you only want records that have matching values in both entities.
    •    Use “with or without” when you want all records from the primary entity, regardless of whether they have related records in the joined entity or not. 

Hi ,

You can refer to this discussion also

https://www.outsystems.com/forums/discussion/72279/why-is-it-a-with-or-without-join/

Thanks

Hi,

In outsystems, 

1."With" is like "Full Outer Join"

2. "With or Witihout" is "Left Join"

Regards,

Wasimkhan S

Hi Kushal,

In addition to above answers,

1) With Join - You can use it to fetch all the records from both tables even if there is no match.

2)With or Without - It is similar to an SQL left outer join. It retrieves all records from the table on the left side of the join condition and only the matching records from the table on the right side. If there is no match, it still includes the record from the table on the left side of the join and fills the columns from the table on the right side with NULL values. 

Hope it helps to understand the concept.

Thanks.

Hello Kushal Kumar K A ,

With: This is used when we want all records from both entities even there is no match. It’s similar to a “Full Outer Join” in SQL.

With or Without: This is used when you want all records from the primary/left entity, regardless of whether they have related records in the joined entity or not. It’s similar to a “Left Join” in SQL.

In other words, a “With” join will return all records from both entities even there is no match. On the other hand, a “With or Without” join will return all records from the left entity/table and the matching records from the right entity/table. If there is no match, the result is NULL on the secondary entity side.

Thank you
Sunil Botadara

Only With > >  Inner Join

With  >>  Outer Join

With or Without > >  Left Join

Closing this topic.  One year was enough to explain the concept.