How To Merge Two SQL Tables Into Third Table with All Rows?

hi,

to get all the records in both table which is matching you can use below select query

 

 

You have show just two records in your sample. In reality you will have quite a many. Also, the data 'Status' is shared between two uses u001 and u002. This status is of their relationship between them. You cannot assign it to a single user record. 

 

You didn't show the expected output, which you should and should also have more rows in second table.

 

For example, what happens when your second table has rows as:

 

u001   u003   1

u001   u004   0

u001   u005   1

u003   u004   1

u004   u005   0

 

What is the expected output?