The SQL-89 query returns 29853 results where as the SQL-92 query returns 26612 results. FYI this is done in Oracle if that matters. Any help would be appreciated.

ANSI SQL-92 is the standard to which everybody agreed. However, Oracle, Microsoft, and all the rest have added platform-specific features that break well-written SQL code.

The SQL dialect is currently based on the SQL-92 ANSI standard. While it is true that SQL-92 represents a widely implemented “core” of the SQL language, it is nevertheless 30 years old. The absence of ...

“Even if you attempt to write pure, standard SQL-92, you cannot escape rewriting code from one product to another. They disagree about data types, rounding and truncation, vendor-defined ...