use world;
select * from table1 LEFT JOIN table2 ON table1.CountryCode=table2.CountryCode
where table2.CountryCode IS NOT NULL;

select table2.CountryCode from table1 RIGHT JOIN table2 ON table1.CountryCode=table2.CountryCode
where table1.CountryCode IS NULL;