sql嵌套问题

[xingliang812]

有两张表，part品名，qty库存，想得到的结果是将qty表中根据part汇总loc为001和007的数量，然后用left join与part表做关联，得到的结果如result表中显示，没有数量的part也必须显示出来。下面是我用Access的查询做出来的，怎么能用一句SQL语句写出来呢，请教高人

part表
part spec
123 asd
456 fgh
789 jkl

qty表
part loc onhand
123 001 10
123 007 10
123 201 10
456 007 10
456 201 10
789 201 10

result
part spec onhandOfSum
123 asd 20
456 fgh 10
789 jkl

[AcHerat]

select a.part,a.spec,sum(b.onhand) onhandofsum
from part a left join qty b on a.part = b.part and b.loc in ('001','007')
group by a.part,a.spec

[--小F--]

select
 a.part,a.spec,sum(b.onhand) as onhandofsum
from
 part a left join qty b 
on 
 a.part = b.part 
and
 b.loc in ('001','007')
group by
 a.part,a.spec

[叶子]

select a.part,a.spec,sum(b.onhand) onhandofsum
from part a left join qty b on a.part = b.part and b.loc in ('001','007')
group by a.part,a.spec

[帝企鹅已被占用]

3个sql一样的？？

[xingliang812]

谢谢各位前辈们，小弟搞定了

[cutebear2008]

SELECT a.part,a.spec,SUM(b.onhand) FROM 
part a,qty b
WHERE a.part=b.part AND b.loc IN('001','007')
GROUP BY a.part

[勿勿]

不错了，LZ凡事靠自己。。
[Quote=引用 6 楼 cutebear2008 的回复:]
SQL code

SELECT a.part,a.spec,SUM(b.onhand) FROM
part a,qty b
WHERE a.part=b.part AND b.loc IN('001','007')
GROUP BY a.part
[/Quote]