Join two files (aliased as f1 and f2 in the example) on column c1, a common column

Execute SQL-like queries on .csv and .tsv files.
More information: <https://harelba.github.io/q>.
Trick copyright: tl;dr; <https://github.com/tldr-pages/tldr>

q "SELECT * FROM {{path/to/file}} f1 JOIN {{path/to/other_file}} f2 ON (f1.c1 = f2.c1)"

click the source code to copy install q on any operating system with command-not-found.com