SELECT * FROM students WHERE student_id NOT IN (
SELECT student_id FROM europeans
)
Why use a table for each continent though? it will be much more efficient (not to mention normalized) to have a continent identifier field in the students table, which can be joined against a continents table. Also, using capital letters for table is bad practice in my opinion, as conventions say that MySQL reserved words should be capital and it makes it hard to distinguish between them by sight only.
Or
[sql]SELECT STUDENTS.* FROM STUDENTS LEFT JOIN EUROPEANS ON STUDENTS.student_id = EUROPEANS.student_idWHERE EUROPEANS.student_id IS NULL[/sql]
I haven't checked which query (pytrin's or mine) is faster - make some tests.
Also, I would advice you not to use coma operator instead of JOIN keyword.
There are 10 types of people in this world, those who understand binary and those who don't