SELECT distinct
msib.segment1
sum(am.TOTAL_QOH) as xyl
FROM MTL_ONHAND_LOCATOR_V AM,
mtl_system_items_b msib
WIP_CONNECTIONTU wy
WHERE AM.INVENTORY_ITEM_ID = msib.inventory_item_id
--and msib.segment1 in (select finish from WIP_CONNECTIONTU)
and am.ORGANIZATION_ID = msib.organization_id
AND AM.ORGANIZATION_ID = 2
--AND AM.SUBINVENTORY_CODE = 'K07'
and wy.finish=msib.segment1 group by msib.segment1
如果select finish from WIP_CONNECTIONTU输出是2个值但是在MTL_ONHAND_LOCATOR_V AM没数据我又想让他显示出来
输出结果是:
15307377 5
15303660 0
怎么做请高手帮帮忙
msib.segment1
sum(am.TOTAL_QOH) as xyl
FROM MTL_ONHAND_LOCATOR_V AM,
mtl_system_items_b msib
WIP_CONNECTIONTU wy
WHERE AM.INVENTORY_ITEM_ID = msib.inventory_item_id
--and msib.segment1 in (select finish from WIP_CONNECTIONTU)
and am.ORGANIZATION_ID = msib.organization_id
AND AM.ORGANIZATION_ID = 2
--AND AM.SUBINVENTORY_CODE = 'K07'
and wy.finish=msib.segment1 group by msib.segment1
如果select finish from WIP_CONNECTIONTU输出是2个值但是在MTL_ONHAND_LOCATOR_V AM没数据我又想让他显示出来
输出结果是:
15307377 5
15303660 0
怎么做请高手帮帮忙
这种大概怎么写啊am.ORGANIZATION_ID(+) = msib.organization_id
好像不行试了,主要在这个表里无数据MTL_ONHAND_LOCATOR_V AM谁在帮忙看看谢谢了