SQL INTERSECT is query that allows you to select related information from 2 tables, this is combine 2 SELECT statement into 1 and display it out.
INTERSECT produces rows that appear in both queries.that means INTERSECT command acts as an AND operator (value is selected only if it appears in both statements).
The syntax is as follows:
SELECT [COLUMN NAME 1], [COLUMN NAME 2],… FROM [TABLE NAME 1]
INTERSECT
SELECT [COLUMN NAME 1], [COLUMN NAME 2],… FROM [TABLE NAME 2]
EXAMPLE :
We have 2 table name GamesScores, GameScores_new.
Table GameScores
PlayerName | Department | Scores |
Jason | IT | 3000 |
Irene | IT | 1500 |
Jane | Marketing | 1000 |
David | Marketing | 2500 |
Paul | HR | 2000 |
James | HR | 2000 |
Table GameScores_new
PlayerName | Department | Scores |
Jason | IT | 3000 |
David | Marketing | 2500 |
Paul | HR | 2000 |
James | HR | 2000 |
SQL statement :
SELECT PlayerName FROM GameScores
INTERSECT
SELECT PlayerName FROM GameScores_new
Result:
PlayerName |
David |
James |
Jason |
Paul |