Inserting a Zero instead of NULL while performing LEFT OUTER JOIN in MYSQL

CASE WHEN a.fieldname IS NULL 
       THEN 0
       ELSE a.fieldname
END AS fieldname

use ISNULL(field, 0) this will insert zero if the field is NULL