是否可以使用data.table执行SQL non-equi join任务(示例如下)(更快和/或更整洁)?

I have a data table with 3 columns: pid ( a job) , starttime (time when it starts ) and fintime (time when it ends) as made up below:I have a data table with 3 columns: pid ( a job