怎么把这些语句拼起来啊
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月'
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月'
作者: caoyang0299 发布时间: 2011-06-16
case when行列转换
作者: jinjazz 发布时间: 2011-06-16
具体点呗,谢谢诶
作者: caoyang0299 发布时间: 2011-06-16