SELECT T1.name FROM products AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer  =  T2.code WHERE T2.name  =  'Creative Labs' INTERSECT SELECT T1.name FROM products AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer  =  T2.code WHERE T2.name  =  'Sony'
Find the name of product that is produced by both companies Creative Labs and Sony.
SELECT T1.name FROM products AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer = T2.code WHERE T2.name = 'Creative Labs ' INTERSECT SELECT T1.name FROM products AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer = T2.code WHERE T2.name = 'Sony '
select t1 . name from products as t1 join manufacturers as t2 on t1 . manufacturer = t2 . code where t2 . name = value intersect select t1 . name from products as t1 join manufacturers as t2 on t1 . manufacturer = t2 . code where t2 . name = value
Find the name of product that is produced by both companies Creative Labs and Sony .