My Oracle Support Banner

Different Results On Query With Left Join In Oracle 12g vs 18c, 19c, & 21c (Doc ID 3002867.1)

Last updated on FEBRUARY 27, 2024

Applies to:

Oracle Database - Standard Edition - Version and later
Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Exadata Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.


After moving data from Oracle version to version
A SQL statement with LEFT JOIN returns wrong data (not the same as in Oracle


Upgrade from 12.2 to any version from 18c, 19c up to 19.21, or 21c.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.