select *,sf_ff + sf_dhf + sf_cf + sf_scf + sf_ylf + sf_qtf - sf_yff as sf_hj from 客人收费表 where sf_sj='2003-03-21' union all select '合计',sum(sf_ff + sf_dhf + sf_cf + sf_scf + sf_ylf + sf_qtf - sf_yff) from 客人收费表 where sf_sj='2003-03-21'
select *,sum(sf_hj)+sf_ff + sf_dhf + sf_cf + sf_scf + sf_ylf + sf_qtf - sf_yff from ( select *,sf_ff + sf_dhf + sf_cf + sf_scf + sf_ylf + sf_qtf - sf_yff as sf_hj from 客人收费表 where sf_sj='2003-03-21' ) AAA
select sum(sf_hj) as sf_zhj from ( select *,sf_ff + sf_dhf + sf_cf + sf_scf + sf_ylf + sf_qtf - sf_yff as sf_hj from 客人收费表 where sf_sj='2003-03-21' ) AS AAA 这样是可以的~但我想要查询所有的字段,而且还要包括*和sf_hj这个字段,也就是说查出来还要多带一列sf_zhj的字段,我现在只想这样,可以实现吗?在就是上面的方法,都是错误的,我都试过了~~~都编译错误~~~郁闷中~~~~~
union all
select '合计',sum(sf_ff + sf_dhf + sf_cf + sf_scf + sf_ylf + sf_qtf - sf_yff) from 客人收费表 where sf_sj='2003-03-21'
from
(
select *,sf_ff + sf_dhf + sf_cf + sf_scf + sf_ylf + sf_qtf - sf_yff as sf_hj
from 客人收费表
where sf_sj='2003-03-21'
) AAA
from
(
select *,sf_ff + sf_dhf + sf_cf + sf_scf + sf_ylf + sf_qtf - sf_yff as sf_hj
from 客人收费表
where sf_sj='2003-03-21'
) AS AAA
这样是可以的~但我想要查询所有的字段,而且还要包括*和sf_hj这个字段,也就是说查出来还要多带一列sf_zhj的字段,我现在只想这样,可以实现吗?在就是上面的方法,都是错误的,我都试过了~~~都编译错误~~~郁闷中~~~~~
将表结构贴出来