2 tables with similar information. There are n number of Unique Teams and 2 unique Types and 2 Unique Products. So, for each Team there are 4 rows in Table 1
Table 1
Team | Type | Product
_____ |________| _________
Team1 | New | TV
Team1 | New | Laptop
Team1 | Repeat| TV
Team1 | Repeat| Laptop
Team2 | Repeat| TV
Team2 | New | TV
Team2 | New | Laptop
Team2 | Repeat| Laptop
Team3 | New | Laptop
Table 2 – Does not have some Teams; If it has matching Teams, it does not have matching Type; If Teams and Type match, it may not match the Product.
Team | Type | Product
_____ |________| _________
Team1 | New | TV
Team1 | New | Laptop
Team1 | Repeat| TV
Team2 | Repeat| TV
Desired Output Table = Rows that are not in Table 2
Team | Type | Product
_____ |________| _________
Team1 | Repeat| Laptop
Team2 | New | TV
Team2 | New | Laptop
Team2 | Repeat| Laptop
Team3 | New | Laptop
SELECT * FROM table1 WHERE NOT EXISTS SELECT * FROM table2 did not work. Returned no output.