Query [mdb].[dbo].[act_log] Against A Group And Return The Analyst Activity Of Its Members

[STUART MATTHEWS]

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

[hermann1815]

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