SELECT * FROM tbl_TER_Territories t, tbl_TER_TerritoryLevels t2 WHERE t.OwnerID = AND t.FSL_TableCode = AND t.levelid = t2.levelid AND t2.BrokerLevel = 1 and t.parentterritoryId = 5391 --->