TABLE AA TABLE BB
id buy id sell
A 1000 A 100
B 2000 A 200
C 3000 B 200
B 120
B 150
SELECT DISTINCT BB.id as id, (AA.buy-BB.sell) as '剩余量' from AA, BB WHERE BB.id=AA.id GROUP BY BB.id
TABLE AA TABLE BB
id buy id sell
A 1000 A 100
B 2000 A 200
C 3000 B 200
B 120
B 150
SELECT DISTINCT BB.id as id, (AA.buy-BB.sell) as '剩余量' from AA, BB WHERE BB.id=AA.id GROUP BY BB.id
转载于:https://my.oschina.net/u/938257/blog/213059