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;