base:
id
name
adress
country_id

countries:
id
country

select base.name, base.adress, base2.country
  from base
 inner join base2 on base.country_id = base2.id

select base.name, base.adress, countries.country
from base as b left join countries as c
on  b.country_id=c.id