Joining data sources

The data we are working in is often contained in multiple tables. We can create a single, virtual table out of multiple original tables by joining them using common fields or keys. The result is a wider table that contains columns originating from different tables. The rows are matched by the values of the column, key, and fields.