mysql - MySQL Query 未选择所有行

Question

我对以下查询有疑问。不选择 s1_pm_po_item 中没有 s1_pm_po_item.CostCode 值的行。我在这里想念什么？

SELECT s1_pm_po_item.id, s1_pm_costcode.CostCode AS CostCode, s1_pm_po_item.description AS Description, CONCAT( s1_pm_po_item.QtyOrdered, s1_pm_po_item_units.description ) AS QtyOrdered, FORMAT( s1_pm_po_item.UnitPrice, 2 ) AS UnitPrice, FORMAT( QtyOrdered * UnitPrice, 2 ) AS Amount
FROM s1_pm_po_item
INNER JOIN s1_pm_budget_class ON s1_pm_budget_class.id = s1_pm_po_item.CostCode
INNER JOIN s1_pm_budget_item ON s1_pm_budget_item.id = s1_pm_budget_class.BudgetItem
INNER JOIN s1_pm_costcode ON s1_pm_costcode.id = s1_pm_budget_item.CostCode
INNER JOIN s1_pm_po_item_units ON s1_pm_po_item_units.id = s1_pm_po_item.QtyUnit
WHERE s1_pm_po_item.POID =924

标签： mysql