62,072
社区成员
发帖
与我相关
我的任务
分享
SELECT dbo.FM_OrderBill.OrderID, dbo.FM_OrderDetail.SerialNo, dbo.FM_ArrivalBill.CityID, dbo.FM_OrderBill.OrderDate, dbo.FM_OrderDetail.Quantity,
dbo.FM_OrderBill.StatusName, dbo.FM_OrderDetail.BatchNum, dbo.SM_Batch.ArrivalID, dbo.SM_Batch.CartridgeID, dbo.FM_ArrivalBill.ArrivalNum,
dbo.SM_Cartridge.PEN, dbo.SM_Cartridge.ProductNum, dbo.SM_Cartridge.Region, dbo.SM_Cartridge.Color, dbo.SM_Cartridge.CodeName,
dbo.SM_PrjCity.PrjCityID, dbo.SM_PrjCity.ProjectID, dbo.SM_PrjCity.CityID AS PCityID
FROM dbo.FM_OrderBill INNER JOIN
dbo.FM_OrderDetail ON dbo.FM_OrderBill.OrderID = dbo.FM_OrderDetail.OrderID INNER JOIN
dbo.SM_Batch ON dbo.FM_OrderDetail.BatchNum = dbo.SM_Batch.BatchNum INNER JOIN
dbo.FM_ArrivalBill ON dbo.SM_Batch.ArrivalID = dbo.FM_ArrivalBill.ArrivalID INNER JOIN
dbo.SM_Cartridge ON dbo.SM_Batch.CartridgeID = dbo.SM_Cartridge.CartridgeID INNER JOIN
dbo.SM_PrjCity ON dbo.FM_OrderBill.PrjCityID = dbo.SM_PrjCity.PrjCityID