SELECT first_name, last_name, CASE WHEN instituition IS NULL THEN '' ELSE instituition END AS instituition FROM people AS p LEFT JOIN education AS e ON p.id = e.id;