Write Custom MySQL Query

Hi there,

We require a custom MySQL query to return a list of customer email addresses from our database.

The data is spread over two tables.

Table 1 contains a list of email addresses and each entry has a unique ID.

Table 2 contains a list of "Email Address ID's" (as in table 1) and also the subscriber list ID's

------------

As an example :

////TABLE 1

EMAIL ------------------------------------------------------ ID
johnsmith#somerandomemail.com | 6


/// TABLE 2
EMAIL ID ----------------------------------------------- LIST ID
6 10

John Smith has a unique ID of 6 and belongs to a List with an ID of 10.

We would like a MySQL query to return all email addresses from "Table 1" that belong to the List ID from table 2.

----------------------------------------

I will supply screenshots of the our table structure over chat with more information.

*Please only bid if you are confident creating MySQL queries, this will be a very simple task for someone with experience so high bids will be automatically ignored.

Thanks