ASA 7.0 的数据库 使用别名吗?
请问大家:ASA 7.0 的数据库 使用别名吗?
select a.amc , a.htje , b.bfje , isnull(a.htje - b.bfje,a.htje) as qk from
(select "t_ht"."g_mc" amc,sum("t_ht"."h_money") as htje from t_ht group by "t_ht"."g_mc") a ,
(select "t_ht"."g_mc" bmc ,isnull(sum("t_fk"."bf"),0) bfje from t_ht,t_fk
where "t_ht"."bh" = "t_fk"."h_bh"
group by "t_ht"."g_mc") b
where a.amc *= b.bmc
各位: 我这样写。报database error 怎么回事?(在DATA WINDOW SQL 面版中写的)