MySQL - retrieve a value from another table if column is null

SELECT T1.ID, IFNULL(T1.name, T2.name) AS nameFROM firsttable T1LEFT JOIN secondtable T2ON T1.T2_id = T2.id

mysql sql select

Use ISNULL for sql

SELECT T1.ID, ISNULL(T1.name, T2.name) AS nameFROM firsttable T1LEFT JOIN secondtable T2ON T1.T2_id = T2.id

CodeHunter