Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle CROSS JOIN + JOINED TABLE to HiRDB
SQLWays changes cross join with joined table to sub query with joined table.
Oracle:
SELECT * FROM (T1 CROSS JOIN T2) LEFT JOIN T3 ON T3.C1=T1.C1 AND T3.C2=T2.C2;
HiRDB:
SELECT * FROM (SELECT * FROM T1, T2) Swt_Alias LEFT JOIN T3 ON T3.C1=Swt_Alias.C1 AND T3.T2=Swt_Alias.C2;