mysql连接查询查不出_mysql – 右连接查询不起作用

我有两个表：opensalesorder和items.

我想基于item_number从两个表中检索数据,并且它可以正常使用以下查询. (使用内部加入)

SELECT opensalesorder.so_number,items.VendorName,opensalesorder.item_number

FROM `opensalesorder`

INNER JOIN items on opensalesorder.item_number = items.ItemName

WHERE items.ItemType = 'Stock' and opensalesorder.status NOT LIKE 'on po'

GROUP BY opensalesorder.item_number

但是我也想要’items’表中的所有行,即使找不到与opensalesorder和items中的ItemName匹配.

但使用下面的查询似乎不适合我.

SELECT opensalesorder.so_number,items.VendorName,opensalesorder.item_number

FROM `opensalesorder`

RIGHT JOIN items on opensalesorder.item_number = items.ItemName

WHERE items.ItemType = 'Stock' and opensalesorder.status NOT LIKE 'on po'

GROUP BY opensalesorder.item_number

即使左侧没有匹配,右连接也会从右表返回结果.

查询是对的吗？

谢谢