ok so your statement should be like this.
regards.

Ok, I think I am a little lost lets put some data into that table
COUNTRIES
USA - UNITED STATES
DR - DOMINICAN REPUBLIC
MX - MEXICO
PR - PUERTO RICO

ALLOW
DR
MX

What about that.

try this.

SELECT DISTINCT countries.Country_Code, Country_Name FROM countries, allow WHERE countries.Country_Code != allow.Country_Code ORDER BY Country_Name

Regards.

Try that

SELECT Profiles.answer, users.gender, COUNT(Profiles.answer) AS count
FROM Profiles INNER JOIN
users ON users.userid = Profiles.userid
GROUP BY...