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

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
Get step-by-step solutions from verified subject matter experts
