select distinct fseOperatorId, company_name FROM tbl_IMPORT_Operators I WHERE I.eai_batchId = AND I.ownerId = AND I.ownerType = and exists ( select * from tbl_OPR_ClientOperators opr where opr.ownerId= i.ownerId and opr.fsltablecode = i.ownerType and opr.operatorId = i.fseOperatorId ) order by company_name
Operator Id Import Company Name Result
#fseOperatorId##htmleditformat( company_name )#
Profile Completeness Status updated on #qmd_importOperators.recordCount# Operators