把MySql语句转换成Oracle语句 5
selectinv.idid,inv.goods_NogoodsNo,inv.goods_NamegoodsName,inv.goods_StandardgoodsSta...
select
inv.id id,
inv.goods_No goodsNo,
inv.goods_Name goodsName,
inv.goods_Standard goodsStandard,
inv.goods_Model goodsModel,
inv.goods_Price goodsPrice,
inv.dept dept,
inv.speak speak,
inv.goods_Unit goodsUnit,
inv.goods_Weight goodsWeight,
inv.goods_Sort goodsSort,
inv.update_time updateTime,
inv.GiveGoodsCompany giveGoodsCompany,
inv.GoodsAllocation goodsAllocation,
inv.RepertorSum repertorSum,
inv.Remark remark,
goodsnums inventoryQuantity
from
inventory inv
left join
(
select
inventoryid,
huoweiid,
sum(goodsnum) goodsnums
from
inventory_huowei
where
status=1
GROUP BY
inventoryid
) as tab
on inv.id = tab.inventoryid
left join
huowei h
on tab.huoweiid=h.id
where
1=1
having
inventoryQuantity>0
order by
inv.update_time desc
哪位大神知道,帮下忙拜托了 展开
inv.id id,
inv.goods_No goodsNo,
inv.goods_Name goodsName,
inv.goods_Standard goodsStandard,
inv.goods_Model goodsModel,
inv.goods_Price goodsPrice,
inv.dept dept,
inv.speak speak,
inv.goods_Unit goodsUnit,
inv.goods_Weight goodsWeight,
inv.goods_Sort goodsSort,
inv.update_time updateTime,
inv.GiveGoodsCompany giveGoodsCompany,
inv.GoodsAllocation goodsAllocation,
inv.RepertorSum repertorSum,
inv.Remark remark,
goodsnums inventoryQuantity
from
inventory inv
left join
(
select
inventoryid,
huoweiid,
sum(goodsnum) goodsnums
from
inventory_huowei
where
status=1
GROUP BY
inventoryid
) as tab
on inv.id = tab.inventoryid
left join
huowei h
on tab.huoweiid=h.id
where
1=1
having
inventoryQuantity>0
order by
inv.update_time desc
哪位大神知道,帮下忙拜托了 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询