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]