Hi guys, I'm trying to figure out a way to join two tables with non-equi conditions. Basically, something like: SELECT * FROM T1 LEFT JOIN T2 ON T1.COL1 >= T2.COL2 AND T1.COL1 <= T2.COL3; I'm using Phoenix 4.2.0, which doesn't support non-equi joins. Is this feature supported in version 4.3? If not, is there a workaround to make it work in 4.2.0? Thanks in advance! -Jaime
- Non-equi joins Jaime Solano
- Re: Non-equi joins Maryann Xue
- Re: Non-equi joins Jaime Solano
- Re: Non-equi joins Maryann Xue
- Re: Non-equi joins Abe Weinograd
- Re: Non-equi joins Maryann Xue
