解决方案 »
- 急求sqlserver2005简体中文标准版 安装序列号
- 关于“ 备份还原“的几个疑问,请指教!
- RPC执行sp_executesql
- myeclipse,sqlserver和tomcat的问题
- 再问一下: 不显示删除回复显示所有回复显示星级回复显示得分回复 有输出参数的存储过程一定用sp_executesql 并且sql语句的拼接问题
- 有关SQL SERVER2000的日期显示问题
- 急!在线等
- 谁能给我讲解下 left join, right join ,left outer join,right outer join 的用法,区别
- 征求删除节点下所有子节点的方法 表中只有 本节点 和 父节点 值 拜谢!!!
- ado记录集的指针移动问题,在线等待,50分恭候
- 括号
- SQL server 2008建表时的问题
mes_wi.AutoID ,
b_pd.CustomerID ,
c.CustomerName ,
cwo.ProductID ,
b_pd.ProductName ,
cwo.FabDevice ,
cwo.Org ,
cwo.WaferLot ,
cwo.TargetDevice ,
cwo.IsTax ,
cwo.IsReturn ,
mes_wo.Plan_StartTime ,
cwo.WONumber ,
cpo.Cust_PO ,
mes_wi.IsArrived ,
mes_wi.ArrivedTime ,
mes_wi.CartonNo ,
mes_wi.IsIQC ,
mes_wi.IQCTime ,
mes_wi.IsWIP ,
mes_wi.WIPTime ,
mes_wi.IsOutStock ,
mes_wi.OutStockTime ,
cwo.TradeType ,
mes_wi.IsFGIN ,
mes_wi.FGINTime ,
mes_wi.IsScrap ,
mes_wi.ScrapTime ,
mes_wo_wi.WorkorderID ,
mes_wi.IsPKG ,
mes_wi.PKGTime ,
mes_wi.IsShipping ,
mes_wi.ShippingTime ,
mes_wi.DieQty ,
mes_wi.WaferNo ,
mes_wo.WlcspLot ,
mes_wi.Yield ,
mes_wi.LMContext ,
b_pd1.ProductName AS WO_ProductName ,
mes_wi.GoodDie ,
mes_wi.BadDie ,
DATEDIFF(Day, ( SELECT DATEADD(Hour, 8, mes_wop.OutTime) AS OutTime
FROM MES_WorkorderProcess mes_wop
WHERE mes_wop.WorkorderID = mes_wo_wi.WorkorderID
AND mes_wop.Sequence = 1
AND mes_wop.Deleted = 0
), mes_wi.FGINTime) AS ProcessCT
FROM MES_WaferInfo mes_wi
LEFT OUTER JOIN Customer_WO cwo ON cwo.AutoID = mes_wi.CustomerWOID
LEFT OUTER JOIN Customer_PO cpo ON cpo.AutoID = cwo.CustomerPOID
LEFT OUTER JOIN Base_Product b_pd ON b_pd.AutoID = cwo.ProductID
LEFT OUTER JOIN Customer c ON c.AutoID = b_pd.CustomerID
LEFT OUTER JOIN MES_Workorder_WaferInfo mes_wo_wi ON mes_wo_wi.WaferInfoID = mes_wi.AutoID
AND mes_wo_wi.Deleted <> 1
LEFT OUTER JOIN MES_WorkOrder mes_wo ON mes_wo.AutoID = mes_wo_wi.WorkorderID
LEFT OUTER JOIN Base_Product b_pd1 ON b_pd1.AutoID = mes_wo.ProductID
WHERE mes_wi.Deleted = 0
AND cwo.Deleted = 0
AND cwo.WaferLot = 'H7F256'
如果mes_wi.Deleted = 0一下子把数据从10万降到1万,而AND cwo.Deleted = 0 可以从10万降到100,那where就应该这样写:WHERE cwo.Deleted = 0 AND mes_wi.Deleted = 0 AND cwo.WaferLot = 'H7F256'
这里只是一个例子