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
