SELECT DISTINCT sma.BrokerID FROM tbl_Ter_Territories ter, tbl_SMA_BrokerOfficeLink sma WHERE ter.OwnerID = AND ter.OwnerID = sma.MFR_ID AND PrimaryManager = #variables.FSPro_UserID# AND ter.TerritoryID = sma.TerritoryID UNKNOWN USER...