SELECT d.fldProductBrandName, d.fldProvider FROM defaqto_disc_data AS d
JOIN mole_remortgage_products ON mole_remortgage_products.fldProductID = d.fldProductID
UNION
SELECT f.fldProductBrandName,f.fldProvider FROM defaqto_fixed_data AS f
JOIN mole_remortgage_products ON mole_remortgage_products.fldProductID = f.fldProductID;