Smartest query

[Anon]

I have to separate tables with info; 'customers' and 'eu'. Each row in the customers has a lot of values, and one of them is country. The eu table is just 15 rows with all the countries in the europian union.

I want to know if the customer.country equals any of the eu.country rows. How do I do this in a simple way?

[Anon]

I would try something like this:

SELECT
*
FROM
customer
WHERE
country in(select country from eu)