金碟出入库单查询明细sql

SELECT TOP 100 PERCENT dbo.ICStockBill.FInterID, dbo.ICStockBill.FTranType,


dbo.ICTransactionType.FName, dbo.ICStockBill.FDate, dbo.ICStockBill.FBillNo,


dbo.ICStockBill.FUse, dbo.ICStockBill.FDeptID, t_Item_1.FName AS Expr1,


dbo.ICStockBillEntry.FItemID, dbo.t_Item.FName AS Expr2, dbo.ICStockBillEntry.FQty,


dbo.ICStockBillEntry.FPrice, dbo.ICStockBillEntry.FAmount,


dbo.ICStockBillEntry.FNote


FROM dbo.ICStockBill INNER JOIN


dbo.ICStockBillEntry ON


dbo.ICStockBill.FInterID = dbo.ICStockBillEntry.FInterID LEFT OUTER JOIN


dbo.t_Item t_Item_1 ON


dbo.ICStockBill.FDeptID = t_Item_1.FItemID LEFT OUTER JOIN


dbo.ICTransactionType ON


dbo.ICStockBill.FTranType = dbo.ICTransactionType.FID LEFT OUTER JOIN


dbo.t_Item ON dbo.ICStockBillEntry.FItemID = dbo.t_Item.FItemID


where dbo.ICStockBill.FDate>


ORDER BY dbo.ICStockBill.FInterID