If you want to understand the merging systems or combine two data set in stata, this video will definitely help you. Here I showed how to merge, one to one - 1:1 or one to many - 1:many or many to one - many:1, many to many - many:many data sets in stata.
If you like the video please do subscribe and comment.