Join by columns - making the resulting file “wider”. The number of rows in the output is the maximum number of rows across all input files
Join by rows - making the resulting file “taller”. The order of columns/rows in the result depends on the order of the input files.