3.2 IN x EXISTS

# [RUIM]
# Evitar o IN especialmente se a subquery retorna uma grande quantidade de registros 

Select * from Product p where productid IN 
(select productid from TransactionHistory)

# [BOM]

Select * from Product p where EXISTS 
(select productid from TransactionHistory)