Re: Display CONCAT() from second table if not NULL

[Christopher Esbrandt]

I have a solution. The LEFT JOIN was on the right track, but I needed a LEFT OUTER JOIN with a CASE statement.

SELECT p.name, CASE WHEN u.id IS NOT NULL THEN CONCAT(u.lastName, ', ', u.firstName) ELSE null END AS user, p.dueDate
FROM projects p
LEFT OUTER JOIN users u
ON p.uid = u.id
ORDER BY p.id DESC;

Thank you for the help. ^^