[RBASE-L] - need help for query by def

[Mario B�dard]

Hi, i'am sorry but my english is to bad.

I hope someone can help me. I'Am a beginner user of RBase, it's Rbase 6.1.

I want to create a view with Query by def.
The trouble i have, when i create a view with this  where condition:

WHERE

T2.clientno = T1.clientno AND  T3.loanid = T2.loanid AND  T3.term_end = (
select Max (term_end) from terms t5 where t5.loanid = T3.loanid)  and
T2.inactive  IS NULL



ALWAYS Rbase change it for


T2.clientno = T1.clientno AND T3.loanid = T2.loanid AND T3.term_end IN
Max(term_end) from terms t5 where t5.loanid = T3.loanid

Why ????

Thanks a lot

Mario B�dard