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月'
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月' 是这个意思?
缩合,78#,一月
55
第二个 二月
44
最终结果
缩合 78# 一月 二月 三月 四月……
55 44 33 22