SELECT manf
FROM(
    SELECT manf, "pc" as type
    FROM products
    JOIN pc ON pc.model = product.model) as pcs
JOIN (
    SELECT manf, "lt" as type
    FROM products
    JOIN laptop ON laptop.model = product.model) as lps ON lps.manf = pc.manf;