Question: Need help turning this into a left outer join SQL statement LEFT OUTER JOIN: retrieve ProductKey, EnglishProductName, EnglishDescription from the table DimProduct and ProductKey, CultureName,

Need help turning this into a left outer join SQL statement

Need help turning this into a left outer join SQL statement LEFT

LEFT OUTER JOIN: retrieve ProductKey, EnglishProductName, EnglishDescription from the table DimProduct and ProductKey, CultureName, ProductDescription from the table FactAdditionallnternationalProductDescription. Because ProductKey exists in both tables. In the SELECT clause, you prefix the table name to the ProductKey column: DimProduct.ProductKey, FactAdditionalInternationalProductDescription.Productkey. Other columns only exist in one table, they do not need table name prefix. We want all records returned from the table DimProduct no matter a record has or has not a corresponding record in the table FactAdditionalInternationalProductDescription, which means that you need to use the LEFT OUTER JOIN based on DimProduct.ProductKey=FactAdditionalInternationalProductDescription.ProductKey. ( 6 columns and 15537 rows). NOTE the first 209 records do not have the values for the three columns from the table FactAdditionalInternationalProductDescription because there are no matching ProductKeys in FactAdditionalInternationalProductDescription for those records in DimProduct

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!