Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle INNER JOIN to HiRDB

SQLWays places used table first in from query with inner join, if there are tables that used and not used in where query.

Oracle:

FROM T1 [INNER] JOIN T2 ON T1.C1=T2.C1 WHERE T2.C2=expr1

HiRDB:

FROM T2 [INNER] JOIN T1 ON T1.C1=T2.C1 WHERE T2.C2=expr1

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