The answer is join. Connecting two tables based on the values in a common column is called a join operation. is a means for combining columns from one (self-join) or more tables by using values common to each. The five types of JOIN: Inner, Left Outer, Right Outer, Full Outer and Cross.
