OK so anyone with some fundamental SQL knowledge will be able to read the following SQL statement and understand what it’s returning, let’s take a look:
1 2 3 4 5 6 |
SELECT DC.LastName, DC.FirstName, FIS.TotalProductCost FROM FactInternetSales FIS INNER JOIN DimCustomer DC ON FIS.CustomerKey = DC.CustomerKey |
To summarize we’re joining the FactInternetSales table to the DimCustomer table via the foreign key called CustomerKey. From the DimCustomer table we’re returning Continue Reading