Getting record from each campaign

Databases
1

My below MySQL join query returns below result. I want to have only those emails which exist in each of my campaign.

SELECT ts.campaign, ts.date_time, d.email FROM tracking_emails ts INNER JOIN tracking_emails_details d ON(ts.campaign=d.campaign) WHERE ts.email_type = ‘email’ AND date(ts.date_time)>=‘2018-01-01’ and d.email!=‘’ group by d.email

Campaign date_time Email
6725fcd91ee81ff0207c722c0e32a24c 2018-01-30 15:30:33 bass_01@yahoo.com
660031e994eff03808b668ba021ff7e6 2018-02-08 11:38:57 bass_01@yahoo.com
88a036f27d4569a1b1a282cda34952cd 2018-02-20 10:42:26 emailid
2f6d22b66b8de6bda9122286c51f562f 2018-01-25 13:51:59 emailid
a54ef4856d189f4cce661bd71e217118 2018-01-16 12:38:50 bass_01@yahoo.com
a54ef4856d189f4cce661bd71e217118 2018-01-16 12:38:50 emailid
a54ef4856d189f4cce661bd71e217118 2018-01-16 12:38:50 emailid
457adbb09be07f1817ad406387a5894f 2018-02-25 10:02:34 emailid
5fc8883ea9216d1b424048392a3f99d0 2018-02-05 14:56:08 bass_01@yahoo.com
a54ef4856d189f4cce661bd71e217118 2018-01-16 12:38:50 bass_01@yahoo.com
5fc8883ea9216d1b424048392a3f99d0 2018-02-05 14:56:08 emailid
2f6d22b66b8de6bda9122286c51f562f 2018-01-25 13:51:59 emailid@gmail.com
457adbb09be07f1817ad406387a5894f 2018-02-25 10:02:34 emailid@gmail.com
660031e994eff03808b668ba021ff7e6 2018-02-08 11:38:57 emailid
4d9ab2fdb4b1369fecc4d6a2e79caf76 2018-01-17 14:05:29 bass_01@yahoo.com
daf5ecca2cf01dd2847ed2bd7fc0a473 2018-02-27 10:50:50 emailid
5fc8883ea9216d1b424048392a3f99d0 2018-02-05 14:56:08 emailid
88a036f27d4569a1b1a282cda34952cd 2018-02-20 10:42:26 bass_01@yahoo.com
5fc8883ea9216d1b424048392a3f99d0 2018-02-05 14:56:08 emailid

2

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.