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;

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.