Question

把MySql语句转换成Oracle语句

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
哪位大神知道，帮下忙拜托了

Answer 1

这些都是符合sql标准的,没有特殊的,oracle也是通用的
只要没有用到特定的函数,关系数据库之间sql大部分都可以通用

追问

可是这里面不是由mysql的左连接吗，我百度了一下，mysql的左连接和oracle的还是有区别的