怎么把这些语句拼起来啊

[caoyang0299]

select '缩合' , '78#' , fdecimal as 一月 from t_BOS200002318,t_BOS200002318entry
where t_BOS200002318.fid=t_BOS200002318entry.fid and t_BOS200002318.fcombobox4='1月'

select fdecimal4 as 二月 from t_BOS200002318,t_BOS200002318entry
where t_BOS200002318.fid=t_BOS200002318entry.fid and t_BOS200002318.fcombobox4='2月'

select fdecimal4 as 三月 from t_BOS200002318,t_BOS200002318entry
where t_BOS200002318.fid=t_BOS200002318entry.fid and t_BOS200002318.fcombobox4='3月'

[jinjazz]

case when行列转换

[caoyang0299]

具体点呗，谢谢诶

[叶子]

select '缩合' , '78#' , fdecimal as 一月 from t_BOS200002318,t_BOS200002318entry
where t_BOS200002318.fid=t_BOS200002318entry.fid and t_BOS200002318.fcombobox4='1月'
union all
select fdecimal4 as 二月 from t_BOS200002318,t_BOS200002318entry
where t_BOS200002318.fid=t_BOS200002318entry.fid and t_BOS200002318.fcombobox4='2月' 
union all
select fdecimal4 as 三月 from t_BOS200002318,t_BOS200002318entry
where t_BOS200002318.fid=t_BOS200002318entry.fid and t_BOS200002318.fcombobox4='3月' 

是这个意思？

[--小F--]

需要得到什么结果??给个例子看看

[caoyang0299]

第一个select 结果
缩合，78#，一月
55
第二个 二月
44
最终结果
缩合 78# 一月 二月 三月 四月……
55 44 33 22

[FlySQL]

select 
  [缩合],
  [78#], 
  sum(case when [fcombobox4]='1月' then fdecimal else 0 end) as [一月],
  sum(case when [fcombobox4]='2月' then fdecimal else 0 end) as [二月],
  sum(case when [fcombobox4]='3月' then fdecimal else 0 end) as [三月],
  sum(case when [fcombobox4]='4月' then fdecimal else 0 end) as [四月],
  sum(case when [fcombobox4]='5月' then fdecimal else 0 end) as [五月],
  sum(case when [fcombobox4]='6月' then fdecimal else 0 end) as [六月],
  sum(case when [fcombobox4]='7月' then fdecimal else 0 end) as [七月],
  sum(case when [fcombobox4]='8月' then fdecimal else 0 end) as [八月],
  sum(case when [fcombobox4]='9月' then fdecimal else 0 end) as [九月],
  sum(case when [fcombobox4]='10月' then fdecimal else 0 end) as [十月],
  sum(case when [fcombobox4]='11月' then fdecimal else 0 end) as [十一月],
  sum(case when [fcombobox4]='12月' then fdecimal else 0 end) as [十二月]
from 
  [t_BOS200002318] a 
join 
  [t_BOS200002318entry] b
on 
  a.fid=b.fid 
group by
  [缩合],[78#]