skip to main content
Non-Supported SQL-92 functionality : Join and Union operations : CORRESPONDING
 

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