I am trying to get the list of users provided a specific MAILBOX Path. Can someone help me with this?
Try this
SELECT DISTINCT u.LOGINID, mbx.PATH FROM YFS_USER u JOIN MBX_MESSAGE msg ON u.LOGINID = msg.USER_ID JOIN MBX_MAILBOX mbx ON msg.MAILBOX_ID = mbx.MAILBOX_ID ORDER BY u.LOGINID, mbx.PATH;