dbaplus Community

Oct 16, 2022 · Databases

Unlock SQL’s CORRESPONDING Clause to Simplify UNION, INTERSECT, and EXCEPT in HSQLDB

This article explains the standard SQL CORRESPONDING keyword, shows how HSQLDB implements it with UNION, INTERSECT and EXCEPT, demonstrates the optional BY clause for column selection, and discusses its limited support in other dialects such as PostgreSQL.