SELECT f.Name, ANY_VALUE(COALESCE(p.Phone, '-')) AS Phone FROM Firms f
LEFT JOIN Phones p ON p.FirmID = f.ID
GROUP BY f.ID