I have 2 tables in my db and need to get the emails from the first table (list_mike) dependant on the location value in another table (options).
Table 1 - list_mike:
Table 2 - options:
So, what i'm trying to do is....
select email from list_mike
value="south" from options
Not sure how to do this mutli-table query, and any help much appreciated!