select tid, a.sum-b.sumfrom (select tid, sum(num) as sum from A order by tid)a,(select tid, sum(num) as sum from B order by tid)bwhere a.tid = b.tid试一下上面的sql语句行不行
