sql server 2000 两表关系查询

select销售额 from grid1 g1 inner join grid2 g2 on g1.商品编号=g2.商品编号 and g2.商品='保健品'and g1.销售员='营一'
select销售额 from grid1 g1 left outer join grid2 g2 on g1.商品编号=g2.商品编号 and g2.商品='保健品'and g1.销售员='营一'
select销售额 from grid2 g2 right outer join grid1 g1 on g1.商品编号=g2.商品编号 and g2.商品='保健品'and g1.销售员='营一'
select销售额 from grid1 g1，grid2 g2 where g1.商品编号=g2.商品编号 and g2.商品='保健品'and g1.销售员='营一'
select 销售额from grid1 where g1.销售员='营一'and 商品编号in（select 商品编号from grid2 where 商品='保健品'）

写了五种方式：前四个是关系连接，第五个是子查询。把文字的换成对应字段名。
------------------------------------------------------------------
select sum（销售额）from grid1 where 销售员='营一'and 商品编号 not in（select 商品编号 from grid2）
select sum（g1.销售额）from grid1 g1 inner join grid2 g2 on g1.销售员='营一'and g1.商品编号<>g2.商品编号
select sum（g1.销售额）from grid1 g1 left outer join grid2 g2 on g1.销售员='营一'and g1.商品编号<>g2.商品编号
select sum（g1.销售额）from grid2 g2 right outer join grid1 g1 where g1.销售员='营一'and g1.商品编号<>g2.商品编号
select sum（g1.销售额）from grid1 g1,grid2 g2 where g1.销售员='营一'and g1.商品编号<>g2.商品编号

select a.销售额 from grid1 as a
join grid2 as b
on a.商品编号=b.商品编号
where b.商品<>'保健品' and a.销售员='营一'

SELECT SUM(销售额) FROM GRID1 WHERE 商品编号 NOT IN （select 商品编号 from grid2 ）

是不是这个意思啊？

select 销售额 from grid1 as a left join grid2 as b on a.商品编号=b.商品编号
where a. 销售员='营一' and 商品 is not in ('%保健品%')

select 销售额 from grid1 where 销售员='营一' and 商品编号 not in (select 商品编号 from gird2 where 商品 <>'保健品')