In SQL Server, there are two tables with Cardinal set as 1:*, (One to Many). When I am using QuickSight it is asking for Left, Right, Inner or Outer Join.
Now what is meant by 1:* in QS? Is it Left join or Right join?
Asked
Active
Viewed 58 times
0
-
maybe you should first learn the diference https://stackoverflow.com/questions/5706437/whats-the-difference-between-inner-join-left-join-right-join-and-full-join – nbk Oct 07 '22 at 09:33
-
The answer depends entirely on what kind of results you want: there are valid cases for using `LEFT OUTER JOIN`, `INNER JOIN`, and `FULL OUTER JOIN` with all different types of multiplicities - that's why we can't tell you that (e.g. "`1:*` means you should use `LEFT OUTER JOIN`" - because it _might_ or it _might not_ depending on what your data actually represents). – Dai Oct 07 '22 at 09:33