PostgreSQL

PostgreSQL EXISTS

Test whether a subquery returns at least one row.

Use EXISTS

SELECT p.name
FROM products AS p
WHERE EXISTS (
  SELECT 1
  FROM featured_products AS f
  WHERE f.product_name = p.name
);

EXISTS is true as soon as the subquery finds a row. The selected value inside the subquery is not important.