本帖最后由 悠哉游哉 于 2012-10-26 11:23 编辑
家里装了2010，单位新装了系统和2010，结果出现了错误：参数不足，期待是1
可是没记得动过啊，郁闷
select H.日期,H.类别,a.表名,a.计量区域,H.上月读数,H.本月读数,H.本月用量,H.本月费用,a.承担,a.考核,a.倍率,a.栋号,H.本月用量*a.倍率 as 本月计量数 from [计量表$] as a left join (select '电耗' as 类别,表名,日期,上月读数,本月读数,本月用量,本月费用 from [电计量$] as b union all select '水耗' as 类别,表名,日期,上月读数,本月读数,本月用量,本月费用 from [新水计量$] as c union all select '气耗' as 类别,表名,日期,上月读数,本月读数,本月用量,本月费用 from [燃气计量$] as d union all select '公摊' as 类别,表名,日期,上月读数,本月读数,本月用量,本月费用 from [公摊$] as e union all select '总耗' as 类别,表名,日期,上月读数,本月读数,本月用量,本月费用 from [总耗$] as f union all select '其他' as 类别,表名,日期,上月读数,本月读数,本月用量,本月费用 from [陈孝民$] as g ) as H on a.表名 = H.表名
排除了一下，其他透视表在家里和单位仍可用，说明系统和office不是问题。
请各位高人指点！！！
不好意思，上面的有误，实际是：
select H.日期,H.类别,a.表名,a.计量区域,H.上月读数,H.本月读数,H.本月用量,H.本月费用,a.承担,a.考核,a.倍率,a.栋号,H.本月用量*a.倍率 as 本月计量数 from [计量表$] as a left join (select '电耗' as 类别,表名,日期,上月读数,本月读数,本月用量,本月费用 from [电计量$] as b union all select '水耗' as 类别,表名,日期,上月读数,本月读数,本月用量,本月费用 from [新水计量$] as c union all select '气耗' as 类别,表名,日期,上月读数,本月读数,本月用量,本月费用 from [燃气计量$] as d union all select '公摊' as 类别,表名,日期,上月读数,本月读数,本月用量,本月费用 from [公摊$] as e union all select '总耗' as 类别,表名,日期,上月读数,本月读数,本月用量,本月费用 from [总耗$] as f union all select '陈孝民' as 类别,表名,日期,上月读数,本月读数,本月用量,本月费用 from [陈孝民$] as g ) as H on a.表名 = H.表名
|
沪公网安备 31011702000001号 沪ICP备11019229号-2
发表于 2012-10-26 09:03
楼主