Data Model- two relationships for two tables
In data Model, tables-> Is it possible to make for two tables two different relationships for different columns?
I want to make for the same two tables once a inner join relationship and for different columns couple left join.
If it's possible, how can I do it?
Hi Gal Moscona
We're not sure we understood your need.
Can you please provide a SQL statement example that may help us understand your needs?
Or an ilustration of the tables columns and relations you need?
Hi @Yakov Shaul ,
I'm attaching an example marked with a red square, can I make for each relationship a different join? for example for one of the relationship inner join and the ether left join?
The ability to set more than one relationship to a second table will be available in one of our upcoming releases.