A database operation that combines the values of 2 tables based on a condition, or relationship, that exists between those tables.
Following this wikipedia article SQL join I wanted to have a clear view on how we could have joins with …
r inner-join data.table outer-join