mysql - 计算不同表的总和值

这是我的代码：

SELECT barang.id_brg, barang.nm_brg, jen_sat, nm_kat, SUM( IFNULL(  stok_brg.stok, 0 ) ) AS stok, IFNULL( laku, 0 ) AS laku
        FROM barang
        JOIN satuan ON barang.id_sat = satuan.id_sat
        JOIN kategori ON barang.id_kat = kategori.id_kat
        LEFT JOIN stok_brg ON barang.id_brg = stok_brg.id_brg
        LEFT JOIN (
        SELECT barang.id_brg, SUM( IFNULL( brg_laku.dibeli, 0 ) ) AS laku
        FROM barang, brg_laku
        WHERE barang.id_brg = brg_laku.id_brg
        GROUP BY barang.id_brg ASC
        ) AS brg_laku ON barang.id_brg = brg_laku.id_brg
        GROUP BY barang.id_brg ASC

我的代码预览：



问题是我想让列变stak-laku并使其成为列结果，因为你们能得到它对不起我对我的英语不好，所以我不知道该怎么说，希望你们能理解我

最佳答案

看起来您想要列stok和laku之间的区别。如果是这样，请尝试以下操作：

select a.id_brg, a.nm_brg, a.jen_sat, a.nm_kat,a.stok,a.laku, (a.stok-a.laku) as difference
from (SELECT barang.id_brg, barang.nm_brg, jen_sat, nm_kat, SUM( IFNULL(  stok_brg.stok, 0 ) ) AS stok, IFNULL( laku, 0 ) AS laku
    FROM barang
    JOIN satuan ON barang.id_sat = satuan.id_sat
    JOIN kategori ON barang.id_kat = kategori.id_kat
    LEFT JOIN stok_brg ON barang.id_brg = stok_brg.id_brg
    LEFT JOIN (
    SELECT barang.id_brg, SUM( IFNULL( brg_laku.dibeli, 0 ) ) AS laku
    FROM barang, brg_laku
    WHERE barang.id_brg = brg_laku.id_brg
    GROUP BY barang.id_brg ASC
    ) AS brg_laku ON barang.id_brg = brg_laku.id_brg
    GROUP BY barang.id_brg ASC) as a;