data.table joins
library(data.table)
# left join, subsetting left table, on different column names
right_DT[1:100,
.(right_id, right_cols_ls)
][left_DT[1:10,
.(left_id, left_cols_ls)
],
on = c(right_id = 'left_id')]