select mfr.mfr_name from tbl_BRO_Principals bpl with (nolock) inner join tblManufacturers mfr with (nolock) ON bpl.mfrid = mfr.mfr_id where bpl.ownerID = and bpl.ownerType = and bpl.principalID =

Manufacturer Repository: #qryCompany.mfr_name#

Manufacturer Repository

select cdr_dstname from tbl_cdr_distributors with (nolock) where ownerid = and fsl_tablecode = and cdr_recordid =

Distributor Repository: #qryCompany.cdr_dstname#

Distributor Repository

Operator Repository

ANYALL of These Categories

select attrDescription from tbl_ORG_Attributes with (nolock) where attrTypeID = and attrID =

#htmleditformat(qryCat.attrDescription)#

select categoryDescription from tbl_#url.repositoryType#_RepositoryCategories with (nolock) where ( ownerid = or ownerid = 0 ) and ownertype = and categoryid =

#htmleditformat(qryCat.categoryDescription)#

Sorted by priority

Sorted by title

Sorted by upload date