INTERSECT Example | SQL Statements | Teradata Vantage - Example - Advanced SQL Engine - Teradata Database

Assume that two tables contain 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