出来的sql语句大概是 select name, number from db111 where name = 'apple' union select name, number from db222 where name = 'orange' union select "other" as name ,number= (100 - 前面求到的apple数 - 前面求到的orange数) group by name 总数为100 结果 name number apple 11 orange 22 other 67
结果
name number
apple 11
orange 22
other 67