再次求助SQL语句

hw2166

再次求助一条SQL语句，问题：SQL数据库中有A  、 B 两张表，我想通过一条语句实现以下查询结果，即满足按B表的字段进行条件查询，也把A表中同字段的数求和，我对复杂查询不太行，谁能帮个忙，谢谢

小羊爱主

1. select A.style_id,A.cloth.id,sum(A.size1),sum(A.size2),sum(A.size3),sum(A.size4),sum(A.size5),B.year,B.jijie,B.style_name from A A,B B where B.year='2007';

复制代码

amazeyeli

[code=sql]--我好奇的是你数据库中的表怎么会放到Excel中
SELECT a.style_id,a.cloth_id,
       SUM(ISNULL(size1,0)) AS size1,
       SUM(ISNULL(size2,0)) AS size2,
       ...
       SUM(ISNULL(size6,0)) AS size6,
       b.[year],b.jijie,b.style_name
FROM A AS a
JOIN B AS b
ON a.style_id = b.style_id
WHERE b.[year] = 2007
GROUP BY a.style_id,a.cloth_id[/code]

amazeyeli

[code=sql]SELECT a.*,b.[year],b.jijie,b.style_name
FROM
(
  SELECT a.style_id,a.cloth_id,
         SUM(ISNULL(size1,0)) AS size1,
         SUM(ISNULL(size2,0)) AS size2,
         ...
         SUM(ISNULL(size6,0)) AS size6      
  FROM A
  GROUP BY a.style_id,a.cloth_id
) AS a
JOIN B AS b
ON a.style_id = b.style_id
WHERE b.[year] = 2007[/code]

hw2166

呵呵，因为便于求教，所以把数据放在EXCEL中，方便向各位老师请教，我现在用的是VB+SQL正在弄一个小程序，谢谢