SELECT [LastName] AS [Employee_LastName] ,[FirstName] AS [Employee_FirstName] ,[Phone] AS [Employee_Phone] ,[ResellerName] AS [Reseller_ResellerName] ,[Phone] AS [Reseller_Phone] FROM [AdventureWorksDW2017].[dbo].[FactResellerSales] T01 LEFT JOIN [AdventureWorksDW2017].[dbo].[DimEmployee] T02 ON T01.[EmployeeKey] = T02.[EmployeeKey] LEFT JOIN [AdventureWorksDW2017].[dbo].[DimReseller] T03 ON T01.[ResellerKey] = T03.[ResellerKey]