我有两个表:opensalesorder和items。我想根据item_number从两个表中检索数据，它在下面的查询中工作正常。(使用内连接)SELECTopensalesorder.so_number,items.VendorName,opensalesorder.item_numberFROM`opensalesorder`INNERJOINitemsonopensalesorder.item_number=items.ItemNameWHEREitems.ItemType='Stock'andopensalesorder.statusNOTLIKE'onpo'GROUPBYop