我是MySQL的新手,所以想不出如何解决这个问题.这是我的数据表
我想返回3列dtls(详细信息),Purchase_Amount作为贷项,Sale_Amount作为借项
但当Purchase_id=3时,必须 Select Purchase_Amount,且Sale_Amount应为0,反之亦然
所需结果如下图所示
这是对数字3的必选结果
如果我试一试
SELECT *
FROM (
select c.Sale_amount as debit
from yarn c
where c.Sale_id=3
) A,
(
select c2.Purchase_amount as credit
from yarn c2
where c2.Purchase_id=3
) B;
它提供了奇怪的结果
此查询不起作用
SELECT A as debit, B as credit
FROM (
select c.Sale_amount as debit
from yarn c
where c.Sale_id=3
) A,
(
select c2.Purchase_amount as credit
from yarn c2
where c2.Purchase_id=3
) B;
需要帮助.