Avatar

Level 4

Bill,

Thanks.  We must be working with different versions/databases because I don't have the tb_shared_users_2_queues table.  Here is the query(not optimized) that I'm using for 8.2.1.

SELECT email from EDCPRINCIPALENTITY WHERE ID IN
     (SELECT SHARED_QUEUES_ID FROM TB_57 WHERE OID IN
             (SELECT OID FROM TB_57 WHERE SHARED_USERS_ID IN
                     (SELECT OID FROM TB_57 WHERE OID = SHARED_USERS_ID AND SHARED_QUEUES_ID =
                             (select ID FROM EDCPRINCIPALENTITY WHERE canonicalname = ?)))) AND canonicalname <> ?