Joining three tables call_req , act_log and ca_contact. how to fetch analyst name through ca_contact ?
is this what are you looking for?
select top 1000 act_log.description as "Log Description", agt.last_name As "Analyst Last Name", agt.first_name AS "Analyst First Name", cr.ref_num as "Ref Num"
inner join ca_contact as agt on agt.contact_uuid = act_log.analyst
inner join call_req as cr on cr.persid = act_log.call_req_id
Thanks for the query
Retrieving data ...