from sql join to r join code example

Example: r merge inner join

merge(x = df1, y = df2, by = "id", 
      all.x=TRUE)[,c("df1_var1", "df1_var2", "df2_var1")]