SQL能不能搜索这样的结果？

Question

select id,name,sum(sunnum) as total from t1,t2 where t1.id=t2.id group by id,name

Answer 1

想你那种方法查询应该是这样：
----------------------------------
id  | name | sum | subno | subnum
----------------------------------
101 | cpu  | 100 |  001  |  30
----------------------------------
101 |  cpu|  100|  002  |  20
----------------------------------
101 |  cpu|  100|  003  |  50
----------------------------------
102 | cdrom| 100 |  001  |  30
----------------------------------
102 | cdrom | 100 |  002  |  20
----------------------------------
102 | cdrom |  100 |  003  |  50