SELECT user_record.password,user_addresses.street
 FROM `user_record`
 FULL OUTER JOIN `user_addresses`
     ON user_record.id=user_addresses.user_id
 ORDER by user_record.id

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OUTER JOIN `user_addresses` ON user_record.id=user_addresses.user_id ORDER by us' at line 1

select
*
from a
left join b on a.whatever = b.whatever
union
select
*
from a
right join b on a.whatever = b.whatever

SELECT user_record.password,user_addresses.street
FROM `user_record`
LEFT JOIN `user_addresses`
    ON user_record.id=user_addresses.user_id
UNION
SELECT user_record.password,user_addresses.street
FROM `user_record`
RIGHT JOIN `user_addresses`
    ON user_record.id=user_addresses.user_id
ORDER by user_record.id