Hi Guys,
Can someone show me a small, practical example of using INTERSECT please?

Regards & TIA,
Ian

Ian,

SELECT ID FROM Tbl1
INTERSECT
SELECT ID FROM Tbl2

Will give a result set where the same ID values exists in both Tbl1 and Tbl2.

Example:
  Source table values:
    Tbl1.ID: 1,5,8,9
    Tbl2.ID: 5,5,0,3,9

  Result.ID: 5,9
 
 
--
Fernando Dias
[Team Elevate]