大家好:
我对paradox表作了如下的sql语句,但编译器提示“类型不匹配”,代码如下:
query1.sql.text:='select pm,fh,sh,count(*) as che_shu,sum(jing) as z_jing from data where mao>50 group by pm,fh,sh
union
select pm,'焦化厂' as fh,'水冶' as sh,count(*) as che_shu,sum(jing) as z_jing from data where mao<50 group by pm'
同样的sql语句,我对Sql server2000的表操作一点问题都没有,不知道问题出在哪里,请大家指教。
谢谢!
王振亚
2003.11.23
我对paradox表作了如下的sql语句,但编译器提示“类型不匹配”,代码如下:
query1.sql.text:='select pm,fh,sh,count(*) as che_shu,sum(jing) as z_jing from data where mao>50 group by pm,fh,sh
union
select pm,'焦化厂' as fh,'水冶' as sh,count(*) as che_shu,sum(jing) as z_jing from data where mao<50 group by pm'
同样的sql语句,我对Sql server2000的表操作一点问题都没有,不知道问题出在哪里,请大家指教。
谢谢!
王振亚
2003.11.23
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货