0

Data Model- two relationships for two tables

Hi! 

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?

Thank you!

Gal 

3 replies

null
    • Yakov_Shaul
    • 6 yrs ago
    • Reported - view

    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?

    • Gal_Moscona
    • 6 yrs ago
    • Reported - view

    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?  

    Thank you!

    Gal 

    • Dvir_Buzaglo
    • 6 yrs ago
    • Reported - view

    Hi Gal,

    The ability to set more than one relationship to a second table will be available in one of our upcoming releases. 

    Thanks.

Content aside

  • Status Answered
  • 6 yrs agoLast active
  • 3Replies
  • 39Views
  • 4 Following