July 2015 - Mehmet Ozdemir

TSQL pattern matching as part of a table join

By Mehmet Ozdemir | July 9, 2015 |

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:

SELECT		DC.LastName,
			DC.FirstName,
			FIS.TotalProductCost
		
FROM		FactInternetSales FIS
INNER JOIN	DimCustomer DC	ON	FIS.CustomerKey = DC.CustomerKey

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 the LastName and FirstName and…