SELECT DISTINCT DistributorCode FROM qmd_StockedItems SELECT T.Name, T.TerritoryID, D.cdr_dstcode, D.cdr_dstname FROM dbo.tbl_CDR_Distributors D INNER JOIN tbl_TER_Territories T ON D.cdr_territoryid = T.TerritoryID WHERE D.OwnerID = AND D.FSL_TableCode = AND D.cdr_dstcode IN () SELECT * FROM qmd_StockedItems ORDER BY TerritoryName, #_OrderBy#