求救高人,EJB-SQL问题,执行出错

[mustangsong]

select object(o) from FXSpecialSpread o where o.activeFlag = 'A' or o.activeFlag = 'X'

select distinct o.customerNumber from FXSpecialSpread o where
o.activeFlag = 'A' or o.activeFlag = 'X'

select distinct o.customerNumber, o.subAccountNumber from FXSpecialSpread o where
o.activeFlag = 'A' or o.activeFlag = 'X'

前两句是可以执行的,但后面那句却报错,不知道是不是SQL语句有什么问题,请高人指点.
出错信息是:
Error generating findByActiveFlag() query for been FxSpecialSpread(Abstrat schema = FXSpecialSpread).Error=WQRY0048E:Invalid SELECT clause containing an expression, input parameter or multiple elements.

Query = 'select distinct o.customerNumber, o.subAccountNumber from FXSpecialSpread o where
o.activeFlag = 'A' or o.activeFlag = 'X''

开发环境是WSAD+DB2

[whbxm2000]

select distinct o.customerNumber, o.subAccountNumber from FXSpecialSpread o where
o.activeFlag = 'A' or o.activeFlag = 'X'语句有问题，有distinct时只能有一个字段

[mustangsong]

好象去掉了distinct也不行,是不是EJB-SQL就不能查询两个字段的?不会吧

[加减算法]

select object(o) from FXSpecialSpread o where o.activeFlag = 'A' or o.activeFlag = 'X'
能用吗？？
我这怎么老提示object.......出错的
害得我二三十个字段一个个的敲

[mustangsong]

问题还没解决,请大家多多指教!

[mustangsong]

好象争论的人多,解决问题的人少