Simple query, BETWEEN Operator, and a real mess!

Hi All,

Database: 11g R2, version 11.2.0.3.0, STANDARD edition

OS: Red Hat Enterprise Linux Server release 5.3 (Tikanga)

I have a very innocent looking query as follows:

SELECT * FROM t2 JOIN t1 ON t1.num BETWEEN t2.numLow AND t2.numHigh;

which almost never returns!

Note that BETWEEN operator works on the 2 different columns for the low and high range.

Range values are non-overlapping in table t2.

Any suggesstions?

Thanks

DP.