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
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