Oracle使用小结

FROM T_SCM_STORE_IN_DETAIL T1     LEFT JOIN T_EMS_MATERIAL T0     ON T0.ID= T1.MATERIAL_ID

GROUP BY T0.ID,T0.MATERIAL_NO,T0.NAME,T0.SPECIFICATION,T1.PLAN_PRICE,T1.AMOUNT,‘入库‘)
UNION ALL
(SELECT T0.ID MATERIAL_ID,T0.MATERIAL_NO,T0.NAME MATERIAL_NAME,T0.SPECIFICATION,T2.PLAN_PRICE PLAN_PRICE_OUT,T2.AMOUNT AMOUNT_OUT,‘出库‘ as mark

FROM  T_SCM_STORE_OUT_DETAIL T2   LEFT JOIN T_EMS_MATERIAL T0 
ON T0.ID= T2.MATERIAL_ID

GROUP BY T0.ID,T0.MATERIAL_NO,T0.NAME,T0.SPECIFICATION,T2.PLAN_PRICE,T2.AMOUNT,‘出库‘)

Oracle使用小结

标签：ora   flashback   sysdate   nbsp   style   移动   ecif   lte   drop