When we do a Right Anti, we are taking all the rows from B that do not have a match in table A. The logistics department wants a list of products that are in stock, but we don't manufacture ourselves. Left Anti will return all rows from table A that do not have a match on table B. When we do a Left Anti, we are taking all the rows from A that do not have a match in table B. No problem, in this case Left Anti is all you need. Product management called you again, this time they want a list of products that are not in stock to review their strategy. Inner join will return a table with all matching records, excluding everything else. When we do an Inner join, we are taking only the matching rows from table A and table B. They don't want to see any other products as they are not supposed to be in stock. The planning department asked you for a list of products that are in stock.
#CREATE JOIN IN IDATABASE FULL#
When we do a Full Outer, we are taking all the rows from table A and all rows from table B.įull Outer will return a table with all records, matching the ones that are available on both tables. Product management department asked you for a list of all products available for sale. Right Outer will return from table A only the products that are present in table B.
When we do a Right Outer, we are taking all the rows from table B and the matching ones from table A. Now, somebody working at the warehouse wants to know which products we manufacture ourselves.
Left outer will return from table B only the products that are present in table A. When we do a Left Outer, we are taking all the rows from A and the matching ones from table B.
Let's say that somebody in manufacturing wants to know which bikes we have in stock. Let's join those tables using the different combinations of joins available in Power BI: The green rows represent the rows that match on both tables. We have in stock more products than those we manufactured ourselves and this list contains the entire list of products in stock. Let's imagine that we have a bike company and we have in our data warehouse two tables: One with a list of products and price and another one with a list of products that we have in stock.
0 kommentar(er)
