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?
asked July 2nd 19 at 17:57
Find more questions by tags SQLMySQL