mysql - 使用左外连接时，第二个表中的数据会重复

Question

大家早上好。我正在创建一个 MySQL 命令进行此输出。

但是当我尝试时，输出是这样的。

这是我的代码。

select purchorder.PONo,purchorder.ItemCode,purchorder.Description,
purchorder.OrderQty,
receiving.ItemCode,receiving.Description,Receiving.ReceivedQty from purchorder
LEFT OUTER JOIN Receiving on receiving.RIno = purchorder.RINumber where 
purchorder.PONo = 'P0239ROI'
Group BY purchorder.ItemCode;

表格采购订单

表接收

如何实现上面的输出？ (带有黄色标题)

这是最新可能的答案

TYSM

Answer 1

您只需删除 group by 子句并在 SELECT 子句中添加 receiving.RIno 即可实现此目的。

SELECT DISTINCT
    purchorder.PONo,
    purchorder.ItemCode,
    purchorder.Description,
    purchorder.OrderQty,
    receiving.RIno,
    receiving.ItemCode,
    receiving.Description,
    Receiving.ReceivedQty
FROM purchorder
LEFT JOIN Receiving ON receiving.RIno = purchorder.RINumber
AND Receiving.ItemCode = purchorder.ItemCode
WHERE purchorder.PONo = 'P0239ROI'