CompanyName = 
					CASE 
						WHEN b.StaffMember = 0 THEN
							CASE
								WHEN orgID > 0 THEN
									CASE
										WHEN b.orgtype = 'BRO' THEN (select broker_name from tblbrokers where broker_id = b.OrgID)
										WHEN b.orgtype = 'MFR' THEN (select mfr_name from tblmanufacturers where mfr_id = b.OrgID)
										WHEN b.orgtype = 'MSC' THEN (select company from tbl_MSC_FSLibraryUsers where userid = b.OrgID)
										WHEN b.orgtype = 'ASC' THEN (select ascName from tbl_ASC_Associations where AsscID = b.OrgID)
										WHEN b.orgtype = 'OPR' THEN (select CompanyName from tbl_OPR_ClientOperators where operatorID = b.OrgID)
										ELSE 'Unknown Company'
									END
								ELSE
									b.organization
							END
						ELSE
							CASE
								WHEN b.fsl_tablecode = 'BRO' THEN (select broker_name from tblbrokers where broker_id = b.ownerid)
								WHEN b.fsl_tablecode = 'MFR' THEN (select mfr_name from tblmanufacturers where mfr_id = b.ownerid)
								WHEN b.fsl_tablecode = 'MSC' THEN (select company from tbl_MSC_FSLibraryUsers where userid = b.ownerid)
								WHEN b.fsl_tablecode = 'ASC' THEN (select ascName from tbl_ASC_Associations where AsscID = b.ownerid)
								WHEN b.fsl_tablecode = 'OPR' THEN (select CompanyName from tbl_OPR_ClientOperators WHERE operatorID = b.ownerid)
								ELSE 'Unknown Company'
							END
					END