PRODUCTION

DEMO

DEVELOPMENT
select b.broker_id as pkId, b.broker_name as companyName from tblBrokers b where exists ( select * from tbl_LIB_Companies where companyPKeyId = broker_id and companyPType = 'BRO' ) and b.broker_id <> 1665 order by broker_name select c.cho_id as pkId, c.cho_name as companyName from tbl_CHO_Operators c where exists ( select * from tbl_LIB_Companies where companyPKeyId = cho_id and companyPType = 'CHO' ) order by cho_name select d.dstId as pkId, d.dstName as companyName from tbl_DST_Distributors d where exists ( select * from tbl_LIB_Companies where companyPKeyId = dstId and companyPType = 'DST' ) order by dstName select m.mfr_id as pkId, m.mfr_name as companyName from tblManufacturers m where exists ( select * from tbl_LIB_Companies where companyPKeyId = mfr_id and companyPType = 'MFR ' ) and m.mfr_id <> 1984 order by mfr_name
select broker_name as companyName from tblbrokers where broker_id = select cho_name as companyName from tbl_CHO_Operators where cho_id = select dstName as companyName from tbl_DST_Distributors where dstId = select mfr_name as companyName from tblManufacturers where mfr_id =

Invalid #_ownerType#
#htmleditformat( qmd_company.companyName )# Operators Potential Dupes
style="color:red;font-weight:bold;" --->>#htmleditformat( companyName )# (#operatorId#)
#htmleditformat( address )#
#htmleditformat( address2 )#
#htmleditformat( city )#, #htmleditformat( state )# #htmleditformat( zipcode )#
#qmd_salesPerson.firstName# #qmd_salesPerson.lastName#
Unassigned
> #htmleditformat( qmd_matchingOperator.companyName )# (#operatorId#)
#htmleditformat( qmd_matchingOperator.address )#
#htmleditformat( qmd_matchingOperator.address2 )#
#htmleditformat( qmd_matchingOperator.city )#, #htmleditformat( qmd_matchingOperator.state )# #htmleditformat( qmd_matchingOperator.zipCode )#
#qmd_salesPerson.firstName# #qmd_salesPerson.lastName#
Unassigned
No Dupe Detected