Avatar

Level 6

Hello,

I understood what do you need.

Here is query:

SELECT  prin.COMMONNAME, prin.EMAIL FROM EDCPRINCIPALENTITY prin
INNER JOIN EDCPRINCIPALGRPCTMNTENTI gr ON prin.id = gr.REFCHILDPRINCIPALID
AND REFPARENTPRINCIPALID = 'Type here group id';