-- Select OwnerType -- Broker Chain Operator Manufacturer

-- Select Broker Manufacturer Chain Operator Library Account -- #htmleditformat( name )# select seg.segmentId, seg.segment from tbl_OPR_ClientSegments cseg inner join tbl_OPR_Segments seg on cseg.segmentId = seg.segmentId where cseg.ownerId = and cseg.fsl_tablecode = group by seg.segmentId, seg.segment select * from qmd_clientSegments order by segmentType, segmentName

-- Select Operator Segment -- #iif( url.segmentId eq 0, de("selected=""selected"""), de("") )#>No Segment #segmentType# #repeatString( " ", 2)##segmentName#

Enter (first three digits of) Zipcode:&##160;&##160;

select * from tbl_CHO_Operators where 1 = 1 and = cho_segmentId = and left( cho_zipcode, 3 ) = and cho_crmActive = 'Y' order by cho_name select * from tbl_OPR_ClientOperators copr left outerinner join tbl_OPR_ClientSegments cseg on copr.oprSegment = cseg.clientSegId and copr.ownerId = cseg.ownerId and copr.fsltablecode = cseg.fsl_tablecode left outerinner join tbl_OPR_Segments seg on cseg.segmentId = seg.segmentId where copr.ownerId = and copr.fsltablecode = and cseg.segmentId = and left( copr.zipcode, 3 ) = select distinct oprSegment from qmd_clientOperators select territoryId from tbl_TER_ZipcodeLink where zip3D_id = ( select zip3D_id from tbl_UT_Zipcodes_3D where zipcode_3d = ) select * from qmd_matchingOperators where oprSegment in ( ) select * from qmd_matchingOperators where oprSegment in ( ) select * from tbl_OPR_ClientOperators copr inner join tbl_OPR_ClientSegments cseg on copr.oprSegment = cseg.clientSegId and copr.ownerId = cseg.ownerId and copr.fsltablecode = cseg.fsl_tablecode inner join tbl_OPR_Segments seg on cseg.segmentId = seg.segmentId where copr.ownerId = and copr.fsltablecode = and cseg.segmentId = and left( copr.zipcode, 3 ) = and operatorId not in ( ) order by oprType

1FS Operators (#qmd_operators.recordCount#)	#qmd_account.name# Operators (#qmd_clientOperators.recordCount#)
#htmleditformat( cho_name )# #cho_address# #cho_address2# #cho_city# #cho_state# #cho_zipcode#	(#_oprType#) #htmleditformat( _companyName )#&##160;#_operatorId# #htmleditformat( _dbaName )# #_address# #_address2# #_city# #_state# #_zipcode# (affiliated with #_cmcCompanyName#)
	(#oprType#) #htmleditformat( trim( companyName ) )#&##160;#operatorId# #htmleditformat( dbaName )# #address# #address2# #city# #state# #zipcode# (affiliated with #valueList( qmd_cmc.companyName )#)