data = merge(data1,data2,by.x = "column1",by.y="column2",all=TRUE) //column1 from data1 and column2 from data2