Do you mean in SQL terms?
Inner join if you want the intersection from both the tables (commonly used)
Left/Right join if you want to converse data from one table but only get the common ones from other
Full Join, you preserve data from both the tables. All the records that are not common will have Nulls populated.