我有 2 个表 1.表
事务在:
+-----+
|id_in|
+-----+
| 2 |
| 2 |
| 1 |
| 3 |
| 2 |
| 3 |
+-----+
2.表事务输出:
+------+
|id_out|
+------+
| 2 |
| 2 |
| 3 |
| 1 |
+------+
我想做一个查询,以便它根据类型在两个表之间产生差异 其中每个的数量由行数 (*( 确定 所以结果是
表查询结果
+--+---------------+----------------+----------------+
|id|count row id_in|count row id_out|(rowin - rowout)|
+--+---------------+----------------+----------------+
|1 | 1 | 1 | 0 |
|2 | 3 | 1 | 2 |
|3 | 2 | 2 | 1 |
+--+---------------+----------------+----------------+
如何查询?
您可以在下面尝试 -
select idin, count_idin, count_idout, count_idin-count_idout as result
from
(
select idin,count(idin) count_idin from transactionin group by idin
)A inner join
(
select idout,count(idout) count_idout from transactionout group by idout
)B on A.idin=B.idout