single postal code country in zip_code table

number of errors=0
number of warnings=0
Group=chkGrpPostalCode

select countrycode from postalcode_source where hassinglecode and not exists (select 1 from zip_code where zip_code.countrycode=postalcode_source.countrycode and zip=singlepostalcode)

countrycode