Custom SQL Query

[Ron]

Hi guys

I am logged into phpmyadmin and want to execute a query where campaign track open table subscriber ID should match with the main mw_list_subscriber subscriber.id and should download all the subscribers who have opened any campaign...

What could be the query??
correct me here

Select * from mw_list_subscriber where mw_campaign_track_open.subscriber_id=mw_list_subscriber.subscriber_id;

 

[twisted1919]

@Ron -

SELECT s.* FROM mw_campaign_track_open t INNER JOIN mw_list_subscriber s ON s.subscriber_id = t.subscriber_id LIMIT 100;

 

[Ron]

@Ron -

SELECT s.* FROM mw_campaign_track_open t INNER JOIN mw_list_subscriber s ON s.subscriber_id = t.subscriber_id LIMIT 100;

Thanks champion..works perfect..!