这个关联查询一下就可以select a.ida as id ,(a.numa+isnull(b.numb,0)) as num from sa a left join sb b on a.ida=b.idbunion allselect b.idb as id ,b.numb as num from sa a right join sb b on a.ida=b.idb where a.ida is null
