select w.ownerId, w.ownerType, m.mfr_name clientName
from tbl_WRK_UserRequests w
inner join tblManufacturers m
on m.mfr_id = w.ownerId
where w.disposition = '?'
and w.ownerType = 'MFR'
union
select w.ownerId, w.ownerType, b.broker_name clientName
from tbl_WRK_UserRequests w
inner join tblBrokers b
on b.broker_id = w.ownerId
where w.disposition = '?'
and w.ownerType = 'BRO'
order by clientName
Workflow Client:
select w.requestId, w.ownerId, w.ownerType, w.requestKey, w.toUserId, w.fromUserId, w.requestURL, w.handlerTemplatePath, w.requestTime, w.disposition, w.config, w.requestTitle, w.requestSubject, w.response, w.responseTime, w.requestTrackingCode, w.responseDueDate, w.sendDispositionNotification,
tu.firstName toFirstName, tu.lastName tolastName, tu.email toEmail,
fu.firstName fromFirstName, fu.lastName fromlastName, fu.email fromEmail
from tbl_WRK_UserRequests w
left outer join tbl_Fspro_members tu
on tu.fspro_userid = w.toUserId
left outer join tbl_Fspro_members fu
on fu.fspro_userid = w.fromUserId
where w.ownerId =
and w.ownerType =
and w.disposition = '?'
order by w.requestTime