Need a MySQL query (this one's easy for advanced people)

[multimediocrity]

I need a query that can display only the rows which have the correct 'color' variable in a corresponding table.

If I have these tables:


Table 1:

id num color
1 1 yes
2 2 yes
3 3 yes
4 4 no
5 5 no
6 6 yes



Table 2:

id num answer
1 1 345
2 2 456
3 3 567
4 4 875
5 5 342
6 6 801


I want to display from Table 2 all data in the 'answer' field UNLESS the corresponding 'num' in Table 1 has 'yes' in the 'color' field.

So I want to display only:
875
342

Thanks!

[stuffonmymate]

Assuming that the table2.num corresponds to table1.id try the following

SELECT t2.answer FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.num WHERE t1.color = 'no';