insert into t1 values(1,'山田花子');
insert into t1 values(2,'山田太郎');
insert into t2 values(1,1,'アメリカ');
insert into t2 values(2,1,'イギリス');
select '--t1--';
select * from t1;
select '--t2--';
select * from t2;
select '--結果--';
select t1.id,t1.名前,min(t2.国) as 国
from t1
left join t2 on t2.t1id = t1.id
group by t1.id,t1.名前;