select companyname as accountName from tbl_opr_clientoperators where operatorid = and ownerid = and fsltablecode = select cdr_dstname as accountName from tbl_cdr_distributors where cdr_recordid = and ownerid = and fsl_tablecode = select cdr_dstname from tbl_cdr_distributors where cdr_recordid = and ownerid = and fsl_tablecode = select companyName from tbl_opr_clientoperators where operatorid = and ownerid = and fsltablecode = select stageId, likelihoodPercent, stageName from tbl_SPL_Stages with (nolock) where ownerId = and ownerType = and statusCode = 'R' select stageId, likelihoodPercent, stageName from tbl_SPL_Stages with (nolock) where ownerId = and ownerType = and statusCode = 'A' order by likelihoodPercent
Lost Business
Type
Account
Account:  #qryPartnerInfo.accountName#
Account    prev acct
Sales Person
Item
    Annual #qmd_unitOfMeasure.unitOfMeasurePlural#*
    Effective Date*
    Competitor
    Reason*
    Recycle Date
    Notes