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
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
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
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
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