主题：SQL语句的更改

再次麻烦老师帮我修改一下！！！！

cmd.CommandText = "select sys_user, 年, 母猪存栏数, 肉猪存栏数_年末, 肉猪存栏数_年初, 肉猪销售数 f rom" & _

"(Select sys_user, year(日期) As 年, avg(母猪_总) As 母猪存栏数, 0 As 肉猪存栏数_年末, 0 As 肉猪存栏数_年初, 0 As 肉猪销售数 f rom (select * f rom {母猪存栏结构}) as b where month(日期)= 12 group by sys_user, year(日期) u nion all " & _

"Select sys_user, year(日期), 0, 合计, 0 f rom{肉猪存栏结构} where month(日期) = 12 u nion all " & _

"Select sys_user, year(日期), 0, 0, 合计 f rom{肉猪存栏结构} where month(日期) = 1 u nion all " & _

"Select sys_user, year(销售_日期), 0, 0, 0, count(销售_日期) f rom {肉猪信息} group by year(销售_日期), sys_user) " & _

"As a where [sys_user] = '" & user.Name & "' group by year(日期), sys_user  order by year(日期), sys_user "

cmd.CommandText = "select sys_user, 年, 母猪存栏数, 肉猪存栏数_年末, 肉猪存栏数_年初, 肉猪销售数 f rom" & _

"(Select sys_user, year(日期) As 年, avg(母猪_总) As 母猪存栏数, 0 As 肉猪存栏数_年末, 0 As 肉猪存栏数_年初, 0 As 肉猪销售数 f rom (select * f rom {母猪存栏结构}) as b where month(日期)= 12 group by sys_user, year(日期) u nion all " & _

"Select sys_user, 日期, 0, 合计, 0, 0 f rom{肉猪存栏结构} where month(日期) = 12 u nion all " & _

"Select sys_user, 日期, 0, 0, 合计, 0 f rom{肉猪存栏结构} where month(日期) = 1 u nion all " & _

"Select sys_user, year(销售_日期), 0, 0, 0, count(销售_日期) f rom {肉猪信息} group by year(销售_日期), sys_user) " & _

"As a where [sys_user] = '" & user.Name & "' group by year(日期), sys_user  order by year(日期), sys_user "

cmd.CommandText = "Select sys_user, 年, 母猪存栏数, 肉猪存栏数_年末, 肉猪存栏数_年初, 肉猪销售数 f rom" & _

"(Select sys_user, year(日期) As 年, avg(母猪_总) As 母猪存栏数, 0 As 肉猪存栏数_年末, 0 As 肉猪存栏数_年初, 0 As 肉猪销售数 f rom (select * f rom {母猪存栏结构}) as b where month(日期)= 12 group by sys_user, year(日期) u nion all " & _

"Select sys_user, year(日期), 0, 合计, 0, 0 f rom{肉猪存栏结构} where month(日期) = 12   u nion all " & _

"Select sys_user, year(日期), 0, 0, 合计, 0 f rom{肉猪存栏结构} where month(日期) = 1   u nion all " & _

"Select sys_user, year(销售_日期), 0, 0, 0, count(销售_日期) f rom {肉猪信息} group by sys_user, year(销售_日期))" & _

"as a group by 年, sys_user, 母猪存栏数, 肉猪存栏数_年末, 肉猪存栏数_年初, 肉猪销售数"

终于可以了，谢谢有点蓝老师！

cmd.CommandText =  "Select sys_user, 年, sum(母猪存栏数) As 母猪存栏数, sum(肉猪存栏数_年末) As 肉猪存栏数_年末, sum(肉猪存栏数_年初) As 肉猪存栏数_年初, sum(肉猪销售数) As 肉猪销售数 f rom " & _

"(Select sys_user, year(日期) As 年, avg(母猪_总) As 母猪存栏数, 0 As 肉猪存栏数_年末, 0 As 肉猪存栏数_年初, 0 As 肉猪销售数 f rom {母猪存栏结构}  group by sys_user, year(日期)  u nion all " & _ 

"Select sys_user, year(日期), 0, 合计, 0, 0 f rom{肉猪存栏结构} where month(日期) = 12 u nion all " & _ 

"Select sys_user, year(日期), 0, 0, 合计, 0 f rom{肉猪存栏结构} where month(日期) = 1 u nion all " & _ 

"Select sys_user, year(销售_日期), 0, 0, 0, count(销售_日期) f rom {肉猪信息} group by sys_user, year(销售_日期)) " & _ 

"As a where sys_user='" & user.Name & "' group by 年, sys_user"