Hi,
SELECT dbo.act_log.description as Description, ca_contact_1.last_name AS "Group", dbo.call_req.ref_num as Ticketnumber, dbo.ca_contact.last_name as LastName, dbo.ca_contact.first_name as GroupMember
FROM dbo.act_log INNER JOIN
dbo.ca_contact ON dbo.act_log.analyst = dbo.ca_contact.contact_uuid INNER JOIN
dbo.grpmem ON dbo.ca_contact.contact_uuid = dbo.grpmem.member INNER JOIN
dbo.call_req ON dbo.act_log.call_req_id = dbo.call_req.persid INNER JOIN
dbo.ca_contact AS ca_contact_1 ON dbo.grpmem.group_id = ca_contact_1.contact_uuid WHERE contact_1.last_name = '...' order by ca_contact_1.last_name
Original Message:
Sent: Mar 30, 2023 10:32 PM
From: STUART MATTHEWS
Subject: Query [mdb].[dbo].[act_log] Against A Group And Return The Analyst Activity Of Its Members
Hi There, I want to query the [mdb].[dbo].[act_log] against a specific group, and return all of the analyst activity of that groups members, broken down by individuals.
I'm assuming it needs multiple table joins to achieve this:
[mdb].[dbo].[call_req]
[mdb].[dbo].[act_log]
[mdb].[dbo].[ca_contact]
[mdb].[dbo].[grpmem].[member]
Anyone out there achieved this?
Thanks
Stuart