Skip to Content (Press Enter)
2024-04-09 17-09-24
Elisa Amaral
67Views
1Comments
Solved
Aggregate joins and data relationships correspondance
Question
Aggregate
Database
New to OutSystems

Hello, 

I've completed the guided path on advanced aggregates and I'd like to know if there's a direct association between the types of joins and the types of data relationships, that is, if each one of the types of joins from aggregates (Only With [INNER JOIN], With or Without [LEFT JOIN], With [FULL OUTER JOIN]), corresponds to a each one of the types of relationships (one-to-one, one-to-many, many-to-many), in that respective order: 

Only With (INNER JOIN)  <=> One-to-One Relationship

With or Without (LEFT JOIN)   <=> One-to-Many Relationship 

Only With (FULL OUTER JOIN)  <=> Many-to-Many Relationship 


0
0
16 Apr 2024
Copy Link
2024-03-22 09-17-23
Chandra Vikas Sharma
Solution

Hi Elisa,

  1. There is no direct relationship between type of join and type of data relationship. Both we are using with differently. Like in full outer join we can manage with two tables but for achiving many to many relationship we create 3rd junction entity to achive this. Below documentation link more clear you about data relationship https://success.outsystems.com/documentation/11/building_apps/data_management/data_modeling/entity_relationships/             Thanks CV 
1
0
16 Apr 2024
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.