夜空中最亮的那颗星 2016-09-23 09:56 采纳率: 0%
浏览 873

sql语句变成mysql...............................

select top 10 ,(select count() from (select * from (
select d.cardid,a.CompID,b.OrderType,b.RevokeState,b.IsResting,d.IsDelete,b.CreateTime,a.GoodsCode,a.number from
OrderDetail a left join OrderLog b on a.OrderCode=b.BillCode and a.CompID=b.CompID left join MemCard d on b.MemID=d.Id left join goods good on good.id=a.GoodsID and good.CompID=a.CompID)t
where CompID = 11187 AND OrderType = 2 AND RevokeState = 0 AND IsResting = 1 AND IsDelete = 0 AND CreateTime>='20160916053625' AND CreateTime<='20160923053625' and goodscode in (GoodsOrderHZ.GoodsCode)
)a where cardid='0000') as Fit,
(select count(*) from (

select * from (

select d.cardid,a.CompID,b.OrderType,b.RevokeState,b.IsResting,d.IsDelete,b.CreateTime,a.GoodsCode,a.number from
OrderDetail a left join OrderLog b on a.OrderCode=b.BillCode and a.CompID=b.CompID left join MemCard d on b.MemID=d.Id left join goods good on good.id=a.GoodsID and good.CompID=a.CompID)t
where CompID = 11187 AND OrderType = 2 AND RevokeState = 0 AND IsResting = 1 AND IsDelete = 0 AND CreateTime>='20160916053625' AND CreateTime<='20160923053625' and goodscode in (GoodsOrderHZ.GoodsCode)
) a where cardid<>'0000') as Members,
'' as AvgProfit from
(select * from (select GoodsID,MAX(GoodsName)GoodsName,MAX(GoodsCode)GoodsCode,SUM(Number) TotalNum ,SUM(TotalMoney)as TotalMoney,sum(profit) profit from
(select a.GoodsID,a.GoodsName,a.CompID,a.GoodsCode,a.Number,a.TotalMoney,a.profit,b.OrderType,b.RevokeState,b.IsResting,b.BillCode,b.CreateTime,b.Remark,d.CardID,d.IsDelete,d.CardName,good.price as GoodPrice from
OrderDetail a left join OrderLog b on a.OrderCode=b.BillCode and a.CompID=b.CompID left join MemCard d on b.MemID=d.Id left join goods good on good.id=a.GoodsID and good.CompID=a.CompID)o
where CompID = 11187 AND OrderType = 2 AND RevokeState = 0 AND IsResting = 1 AND IsDelete = 0 AND CreateTime>'20160916053625' AND CreateTime<='20160923053625 '
group by GoodsID )x left join (select GoodsID as GoodsStockID,SUM(StockNum)as tstocknum from GoodsStock where CompID=11187 AND ShopID in (select id from Shop where compid=11187)
group by GoodsID)y on x.GoodsID=y.GoodsStockID)as GoodsOrderHZ order by totalnum desc

  • 写回答

1条回答 默认 最新

报告相同问题？

悬赏问题

  • ¥60 Python如何后台操作Vmwake虚拟机键鼠
  • ¥15 关于#matlab#的问题：期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707，使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错，维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯：Person is not mapped，如何解決？
  • ¥15 c++头文件不能识别CDialog
  • ¥15 Excel发现不可读取的内容