update szallito set orszag=isnull(
(select iso from orszagok where orszagok.iso=LEFT(szallito.orszag,2)),'')


update vevok set iso=
(select iso from orszagok where orszagok.iso=LEFT(vevok.orszag,2))



update vevok set liso='' where liso is null
update vevok set lallam='' where lallam is null
update vevok set allam='' where allam is null


update vevo_tel set iso=
(select iso from vevok where vevok.VEVO_KOD=vevo_tel.vevo_kod)

update vevo_tel set allam=
(select allam from vevok where vevok.VEVO_KOD=vevo_tel.vevo_kod)



select * from szallito where orszag not in (select iso from orszagok)
select * from vevok where iso not in (select iso from orszagok)
select * from vevo_tel where iso not in (select iso from orszagok)