Selection error involving field *N

114do

向各位请教，返回信息如下：
select T1.f1 from LIB1/TABLE1 T1, LIB2/TABLE2 T2 where
cast(T2.f1 as int) = T1.f1  
Selection error involving field *N.              

解释一下：T2.f1为CHARACTER-O类型，T1.f1是NUMERIC 类型。

114do

找到一段英文资料解释RRN的，也没看明白，原文如下：
Queries that contain an RRN function in the WHERE clause will   
now result in that selection occuring in the order it is in the
WHERE clause and not deferred until last.  Deferring it until   
last can result in selection errors, which should not occur.

txsrxy

你能说说，你想要什么样的结果。

114do

谢谢各位的关注，问题已经解决了，就是因为表中有重复的record

114do

谢谢各位的关注，问题已经解决了，就是因为表中有重复的record