INTERSECT Example | SQL Statements | VantageCloud Lake - Example: INTERSECT Operator - Teradata Vantage

Assume that table SPart contains the following rows:

Assume that table SLocation contains the following rows:

To then select supplier number (SuppNo) for suppliers located in London (SuppLoc) who supply part number P1 (PartNo), use the following request:

SELECT SuppNo FROM SLocation 
WHERE SuppLoc = 'London' 
INTERSECT 
SELECT SuppNo FROM SPart 
WHERE PartNo = 'P1';

The result of this request is:

SuppNo
------
   101