I have searched for couple of days on ways to get past a limitation on R

(R error: ℹ 3357726064 rows would be returned. 2147483647 rows is the maximum number allowed.)

I have two tables with column called rollnumber. First table has about 110000 rows and the second tables has about 2.6 million. Each table has repeat rollnumber values however there are no duplicates, I checked.

I’m searching for a creative answer on how to get past the limitation. Thank you.