Sometimes a relationship between data sets needs to be more than just an inner join. It would be great to have an advanced editor for relationships where you can define the relationship as you would a JOIN condition in SQL. Inner, left, right joins multiple joins, and even other operators besides just "=" (like <, >, <>, etc).
4 Comments
- It's not a complete solution, but there some advanced Join options when you use the Merge function in Query Editor... You can do inner/outer, left/right/full and anti joins. We don't support multi-joins, but you can create bridging tables and use those. We don't support other operators than "=", but we don't hear many requests for it so until this gets lots of votes we probably won't be able to prioritize that work. Hope that helps!
- The joins with other operators than "=" will be very helpful...
- This would be very important improvement for us, Merge function in Query editor may be hard to use for user. We would like to have option to change the relationships between tables at the level of data model imported from SQL server
- Status added:Needs Votes
