Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

See how to join two data sets by one or more common columns using base R’s merge function, dplyr join functions, and the speedy data.table package. R has a number of quick, elegant ways to join data ...

The always resourceful Tech-Recipes has a handy tutorial on how to easily (that's the trick) combine two tables in Microsoft Word. This is something that is supposed to be easy, but usually ends in ...