Subject: Re: bug#26029: Problems with join

From: Reuti <[email-masked]>
Date: Wed, 8 Mar 2017 19:17:14 +0100

Hi,

> Am 08.03.2017 um 18:39 schrieb Peter Kluge <[email-masked]>:
> 
>   Hello Mike Haertel,
> 
>   I've a problem with the join-command
>   2 Files , compare-field  in one file first in the other second filed.
>   Files attached
> 
>   I want as output to have the compare-file and then the rest-content of
>   file_1 followed by the rest-content of file-2
>   Doesn't work. See Script. (also attached)

AFAICS you will need two joins to get the desired output. Otherwise the unpairable records are interleaved in the output. Although getting the unpairable records in a second invocation will always have a fixed order, it's by accident the one you request (add "-v 1 -v 2" in the second invocation).

The strange thing seems to be, that "-j1 2" is handled like "-1 2". "-j 1" should already have an option and "2" would then become the first filename making the last filename in the command line superfluous.

-- Reuti