How can I do a FULL OUTER JOIN in MySQL

This function is used to return the value which is set not to be null in the list. In case all values in the list are null the coalesce function will return NULL. Its representation: Coalesce(value1, value2, value3,…)