Здравствуйте, Hard_Club, Вы писали:

Без подзапросов:

select c.*
from tbcountries c
left join tbcashofcountries cc on c.countryID = cc.countryID
where cc.countryid is NULL