How to merge data from two tables?

Question

MySQL

I have table A and B. There is no connection between them, the only way to see the connection is that each table has a user_id column.
I need to make a selection from 2 tables and display the results in this way.
If in some of the tables there is no record by user_id from another table, then fill in the fields with NULLs.
If you use LEFT JOIN ON A.user_id = B.user_id and in table B there is a user who is not in A, then this record will not be displayed.
Likewise in reverse.
Is it really possible to make a SQL query?

Answer 1

It looks like you need a full outer join .

Answer 2

www.sql-tutorial.ru/ru/book_full_join_and_mysql.html