Apologies I know this is simple for people but I have tried lots of different ways and failed.
I need to export
I am using SQL workbench and I need to export to a CSV file all the emails in the "em_subscriber" table that have a status=3 in the "em_subscriber_list". Obviously its the "subscriberid" and "id" fields which are the unique identifier so I need a statement that will join the 2.
Can anyone help me