0554NAME IS NULL垢版2017/11/15(水) 12:29:05.63ID:??? >>548 select T1.* ,T2.hage1 ,T2.hage2 from T1 left join T2 on T1.id = T2.id; とか T2だけカラムを羅列する