Archive2
Highlighted

How to search the chain of users that sent an email

New Member

Hello,

My data are like this,

sender , receiver, _time
userA, userB, _time1
userB, userC, _time2
userB, userD, _time3
userC, userD, _time4

I'd like to find the chain of users that send and receive emails. For example userA->sent to userB-> sent to userC and userD , userC->send to userD

my result would be like this
userA, userB, userC, userD
userA, userB, userD
userB, userC, userD
userC, userD

Can you please help me
Thanks in advance

Tags (1)
0 Karma
Reply