就这句SQL 来讲应该这样写Select 销售编号,Sell.商品编号,sell.数量,商品名称,编号,姓名
From Sell,Employees,Goods Where Sell.售货员工编号=Employees.编号
and sell.商品编号 = Goods.商品编号 and Employees.姓名='赵飞燕'
and Employees.部门='采购部'
and Goods.商品编号=Sell.商品编号
From Sell,Employees,Goods Where Sell.售货员工编号=Employees.编号
and sell.商品编号 = Goods.商品编号 and Employees.姓名='赵飞燕'
and Employees.部门='采购部'
and Goods.商品编号=Sell.商品编号
from Sell,Employees,Goods
where Sell.售货员工编号=Employees.编号 and Goods.商品编号=Sell.商品编号
and Employees.姓名='赵飞燕' and Employees.部门='采购部'
from goods a
left join employee b on b.编号 =a.进货员工编号 and b.编号='1001'
left join Sell c on c.商品编号=a.商品编号
select 销售编号, s.商品编号, s.数量, 商品名称, 编号, 姓名
from Employees as e
join Sell as s
on e.编号 = s.售货员工编号
join Goods as g
on s.商品编号 = g.商品编号
where e.姓名 = '赵飞燕(据说很漂亮)' and
e.部门 = '采购部'