select mfr_name from tblManufacturers with (nolock) where mfr_id = select *, '#_fileOwnerName#' as ownerName, #_fileOwnerId# as fileOwnerId, '#_fileOwnerType#' as fileOwnerType from qrySkuFiles select MFRAbbrev_Name as mfrName, BrokerAbbrevName as broName from tblmanufacturers inner join tblbrokers on broker_id = where mfr_id = select * from qrySkuFiles union select *, '#qryOwnerInfo.broName#' as ownerName, #client.ownerid# as fileOwnerId, '#client.ownerType#' as fileOwnerType from qrySkuFilesClient order by sortrank, UploadDate desc select child_attrId from tbl_org_attributelinks where mstr_attrTypeId = 34 and mstr_attrId = and child_attrTypeId = 75 select child_attrId from tbl_org_attributelinks where mstr_attrTypeId = 34 and mstr_attrId = and child_attrTypeId = 30