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

Join and Union operations

INTERSECT

INTERSECT set operator returns all rows that exist in the intersection of two tables, that is, in both tables.
SELECT * FROM music_titles
INTERSECT SELECT * FROM discontinued_albums;