/* Проверка совпадения территории продажи и территории перепродавца (магазина) */ select fr.* from FactResellerSales as fr inner join DimReseller as r on fr.ResellerKey=r.ResellerKey inner join DimGeography as g on r.GeographyKey=g.GeographyKey inner join DimSalesTerritory as t on g.SalesTerritoryKey=t.SalesTerritoryKey where fr.SalesTerritoryKey<>t.SalesTerritoryKey