Question

Which command should be used to merge data using common columns in multiple tables and?

Answer 1

m=merge(Col_1,Col_2,by="Newcol_name")

Answer 2

The command which is used to merge data using columns in multiple tables is

X= merge(Column_1,Column_2 by="New Column_Name").

Here X stands for the datas to be merged. MERGE is the function name that we are going to perform in this query.

Column_1 and Column_2 are are two columns which are to be merged.

New Column_Name is the name of the newly formed column that contains the merged information of both the columns.