CORRESPONDING

The OpenAccess SDK SQL engine does not support the CORRESPONDING clause.

The CORRESPONDING clause is used for reducing the columns that are included in the result.

Syntax

CORRESPONDING [BY (column_name [, column_name]…)]

Example

SELECT * FROM old_music_titles
UNION CORRESPONDING BY (title, artist, artist_more)
SELECT * FROM new_music_titles