create view viewName As Select a.名称 as 总计,IsNull(sum(b.销量),0) as 总销量 from 表一 a Left Join 表二 b on a.代码 = b.代码
select "总计" as 名称,sum(销量) as 数量 from 表二union select b.名称 as 名称 ,sum(a.销量) as 数量 from 表二 a left join 表一 b on a.代码 = b.代码 group by b.名称 order by b.名称
create view 视图 as select a.名称, sum(b.销量) from 表一 a inner join 表二 b on a.代码 = b.代码 group by a.名称 with cube
create view test as select a.名称,sum(b.销量) 销量 from table1 a,table2 b where a.代码=b.代码 group by a.名称 union select '总计',sum(b.销量) 销量 from table1 a,table2 b where a.代码=b.代码
create view test as select a.名称,sum(b.销量) 销量 from table1 a,table2 b where a.代码=b.代码 group by a.名称 union all select '总计',sum(b.销量) 销量 from table1 a,table2 b where a.代码=b.代码
Select a.名称 as QQ,IsNull(sum(b.销量),0) as 总销量 from 表一 a Left Join 表二 b on a.代码 = b.代码 group by QQ union all select 总计 as QQ,isnull(sum(b.销量),0) as 总销量 from 表一 a Left Join 表二 b on a.代码=b.代码 order by QQ desc
create view 视图 as select a.名称, sum(b.销量) from 表一 a inner join 表二 b on a.代码 = b.代码 group by a.名称 with cube
create view viewName As Select a.名称 as 总计,IsNull(sum(b.销量),0) as 总销量 from 表一 a Left Join 表二 b on a.代码 = b.代码 group by a.名称
As
Select a.名称 as 总计,IsNull(sum(b.销量),0) as 总销量
from 表一 a
Left Join 表二 b on a.代码 = b.代码
select b.名称 as 名称 ,sum(a.销量) as 数量 from 表二 a left join 表一 b on
a.代码 = b.代码
group by b.名称
order by b.名称
as
select a.名称, sum(b.销量) from 表一 a inner join 表二 b on a.代码 = b.代码 group by a.名称 with cube
as
select a.名称,sum(b.销量) 销量 from table1 a,table2 b where a.代码=b.代码 group by a.名称
union
select '总计',sum(b.销量) 销量 from table1 a,table2 b where a.代码=b.代码
as
select a.名称,sum(b.销量) 销量 from table1 a,table2 b where a.代码=b.代码 group by a.名称
union all
select '总计',sum(b.销量) 销量 from table1 a,table2 b where a.代码=b.代码
from 表一 a
Left Join 表二 b on a.代码 = b.代码
group by QQ
union all
select 总计 as QQ,isnull(sum(b.销量),0) as 总销量
from 表一 a
Left Join 表二 b on a.代码=b.代码
order by QQ desc
as
select a.名称, sum(b.销量) from 表一 a inner join 表二 b on a.代码 = b.代码 group by a.名称 with cube
As
Select a.名称 as 总计,IsNull(sum(b.销量),0) as 总销量
from 表一 a
Left Join 表二 b on a.代码 = b.代码
group by a.名称