select name from tbl_TER_Territories where ownerId = 1382 and fsl_tablecode = 'MFR' and territoryId = select operatorId from tbl_OPR_ClientOperators where ownerId = 1382 and fsltablecode = 'MFR' and comments like 'technomic%' and state in ( ) update tbl_OPR_CLientOperators set territoryId = where operatorId in ( ) and ownerId = 1382 and state in ( ) and fsltablecode = 'MFR'

#htmleditformat( qmd_territoryLookup.name )# : #qmd_operators.recordCount#

Total: #_totalOperators#