How to merge data from two tables?

I have a table A and B. no communication Between them, only than you see the relationship in each table has a column user_id.

I need to make a selection from 2 tables and display results accordingly.

If some of the tables there is no entry for user_id from another table to populate the fields NULLами.

If you use a LEFT JOIN ON A. user_id = B. user_id and table B has the user which is not in A, then this entry will not appear.
Similarly, in the reverse order.

This SQL query?
July 2nd 19 at 17:57
2 answers
July 2nd 19 at 17:59
Solution
It seems that you need full outer join.
July 2nd 19 at 18:01

Find more questions by tags SQLMySQL