sql-server - 不等于在 sql 查询中不起作用

Question

您好，我尝试使用以下查询从表中获取数据，但它不起作用..

    SELECT
    ProductMaster.ProductName + '(' + CONVERT(nvarchar(10), 0) + ')' AS orderedproducts,
    BranchName + '(' + CONVERT(nvarchar(10), SUM(StockInward.Qty)) + ')' AS currentstock,
    Setup.Id AS BranchId
FROM ProductMaster
INNER JOIN StockOutward
    ON ProductMaster.Productid = StockOutward.productid
INNER JOIN stockinward
    ON ProductMaster.Productid = stockinward.productid
    AND stockinward.StockLocation <> StockOutward.Location
INNER JOIN Setup
    ON stockinward.stocklocation = Setup.id
WHERE StockOutward.ProductId = '7'
GROUP BY    ProductMaster.ProductName,
            StockOutward.Qty,
            BranchName,
            Setup.Id

它正在显示 StockOutward 表中的所有记录。

Answer 1

尝试在您的内部连接中将您的 <> 移动到 where 子句中。在您的示例中，您是否尝试过更简单的查询(选择 1 个简单元素并逐个添加 innerjoin。