select c.BID_ORGAN_ID, d.COR_NAME, a.COMMODITY_NAME, a.COMMON_NAME, a.MEDFORM_NAME, a.MED_SPECIFY, a.MED_UNIT, a.PRICE, a.PRODUCER_NAME, a.PRODUCT_ID, b.CONTRACT_NUMBER from TBL_CONTRACT_MANAGE c, TBL_COR_INFO d, TBL_ORDERFORM_LIST a, TBL_ORDERFORM_MANAGE b where c.BID_ORGAN_ID=d.ORGAN_ID and b.CONTRACT_NUMBER=c.CONTRACT_NUMBER and a.ORDERFORM_NUMBER=b.ORDERFORM_NUMBER and a.PROJECT_ID='221' and a.HOSPITAL_ID='yc001' and b.ORDERFORM_NUMBER_ORDER='1' order by c.BID_ORGAN_ID--看了一下沒有問題 請樓主說明具體 的出錯環境和出錯內容
是否用到 union all?
d.COR_NAME,
a.COMMODITY_NAME,
a.COMMON_NAME,
a.MEDFORM_NAME,
a.MED_SPECIFY,
a.MED_UNIT,
a.PRICE,
a.PRODUCER_NAME,
a.PRODUCT_ID,
b.CONTRACT_NUMBER
from TBL_CONTRACT_MANAGE c,
TBL_COR_INFO d,
TBL_ORDERFORM_LIST a,
TBL_ORDERFORM_MANAGE b
where c.BID_ORGAN_ID=d.ORGAN_ID
and b.CONTRACT_NUMBER=c.CONTRACT_NUMBER
and a.ORDERFORM_NUMBER=b.ORDERFORM_NUMBER
and a.PROJECT_ID='221'
and a.HOSPITAL_ID='yc001'
and b.ORDERFORM_NUMBER_ORDER='1'
order by c.BID_ORGAN_ID--看了一下沒有問題
請樓主說明具體 的出錯環境和出錯內容