First of all apologies for if the syntax and framing of question isn't up to the standards.

I have a MySql database .I have a table answer which contains idquestion, userAnswer, userEmailAddress as columns.

Another table multi\_choice\_pool, which contains idQuestion, answer\_all.

Every answer.userEmailAddress has multiple entries of idQuestion and userAnswer.

I want to obtain userEmailAddress in answer table where id and answer of that userEmailAddress equals the iq and answer of multi\_choice\_pool.

I wrote this:

```
Select answer.userEmailAddress from answer 
where (answer.idQuestion=multi_choice_pool.idQuestion) AND  
(answer.userAnswer=multi_choice_pool.answer_all);

```

Which is giving me an error: "Unknown column 'multi\_choice\_pool' in where clause.

Is the syntax wrong? Or the query is wrong itself? Or my approach isn't right? Can you rectify and provide suggestion?