查询分析器的学习和应用-门外汉的笔记

DECLARE @DEPtno VARCHAR(100)
SELECT @DEPtno ='*DeptNo*'
sELECT b.FBillNo as 单据号 ,
e.FNumber as 物料代码,e.FName as 物料名称,
d.FNumber as 业务员代码 ,d.FName as 业务员 ,
c.FNumber as 部门代码 ,c.FName as 部门名称 ,
a.FQty as 数量 ,a.FPrice as 单价,
a.FAmountincludetax as 金额
FROM ICPurchaseEntry a
left join ICPurchase b
on
a.FInterID=b.FInterID
left join t_Department c
on b.FDeptID=c.FItemID
left join t_Emp d
on b.FEmpID=d.FItemID
le