 加好友  发短信
等级：超级版主
帖子：110813
积分：564003
威望：0
精华：9
注册：2015/6/24 9:21:00
|
 Post By：2019/6/11 21:31:00 [显示全部帖子]
SEL ECT top 1 a.FName AS 物料名称, a.FModel AS 规格型号, a.FNumber AS 物料代码, a.FItemID AS 物料ID, c.FFullNumber AS 供应商代码FROM AIS20181207194554.dbo.t_ICItemCore AS a LEFT OUTER JOIN ‘物料表 AIS20181207194554.dbo.POOrderEntry AS b ON a.FItemID = b.FItemID LEFT OUTER JOIN ’采购订单明细表 AIS20181207194554.dbo.POOrder AS d ON d.FInterID = b.FInterID LEFT OUTER JOIN ‘采购订单总表 AIS20181207194554.dbo.t_Item AS c ON d.FSupplyID = c.FItemIDorder by d.FDate desc
|
|
