cmd.CommandText = "select 年, 销售_母猪 + 销售_公猪 + 销售_肉猪 + 补贴项目 + 其他收入 as 合计 f rom " & _
"(Select YEAR(销售_日期) As 年, sum(销售_母猪) As 销售_母猪, sum(销售_公猪) As 销售_公猪, sum(销售_肉猪) As 销售_肉猪, sum(补贴项目) As 补贴项目, sum(其他收入) As 其他收入 f rom" & _
"(Select 销售_日期, 销售_金额 As 销售_母猪, 0 As 销售_公猪, 0 As 销售_肉猪, 0 As 补贴项目, 0 As 其他收入 f rom {母猪基本信息} where [sys_user]='" & user.Name & "' u nion all " & _
"Select 销售_日期, 0, 销售_金额 As 销售_公猪, 0, 0, 0 f rom {公猪信息} where [sys_user]='" & user.Name & "' u nion all " & _
"Select 销售_日期, 0, 0, 销售_金额 As 销售_肉猪, 0, 0 f rom {肉猪信息} where [sys_user]='" & user.Name & "' u nion all " & _
"Select 日期, 0, 0, 0, 金额 As 补贴项目, 0 f rom {补贴项目} where [sys_user]='" & user.Name & "' u nion all " & _
"Select 日期, 0, 0, 0, 0,金额 As 其他收入 f rom {其他收入} where [sys_user]='" & user.Name & "') as b) " & _
"As a group by 年 order by year 年 "
加好友 
发短信
Post By：2015/8/28 11:41:00 [只看该作者]
