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?

Thank you!


3 replies

    • Yakov_Shaul
    • 5 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
    • 5 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!


    • Dvir_Buzaglo
    • 5 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. 


Content aside

  • Status Answered
  • 5 yrs agoLast active
  • 3Replies
  • 37Views
  • 4 Following