对比两张表的数量解决办法

2012-05-11

对比两张表的数量table_AID NameQuantity1apple52banana13orange1table_BID NameQuantity1apple22banana13

对比两张表的数量
table_A

ID Name Quantity
1 apple 5
2 banana 1
3 orange 1

table_B

ID Name Quantity
1 apple 2
2 banana 1
3 orange 1

查找出table_A的信息条件为：table_A.Quantity-table_B.Quantity>0

结果为：

ID Name Quantity
1 apple 5

[解决办法]
select * from table_A a inner join table_B b on a.Name =b.Name
where a.Quantity-b.Quantity>0
[解决办法]

SQL code

select a.id,a.name,a.quantity from table_a a join table_b on a.id=b.id where table_A.Quantity-table_B.Quantity>0
[解决办法]
SQL codeselect a.id,a.name,a.quantity from table_a a left join table_b b on a.id=b.id where a.Quantity-b.Quantity>0