Hello Maintainer, I am using join v8.5 from debian squeeze.
When using the -v2 option with different join fields in files 1 and 2, the join field which gets moved to the beginning of the result lines is the one identified by the -1 option, not the one identified by the -2 option. Here are my test files: ==== file a ==== axx111 keyX axx222 ayy111 keyY ayy222 ==== file b ==== xxx111 xxx222 keyX xxx333 zzz111 zzz222 keyZ zzz333 now, the command: join -v 2 -1 2 -2 3 a b produces ==== wrong output ==== zzz222 zzz111 keyZ zzz333 instead of ==== expected output ==== keyZ zzz111 zzz222 zzz333 The two following other commands work as expected: join -v 1 -1 2 -2 3 a b join -1 2 -2 3 a b I did not find this problem in your database - or am I mistaken ? Best regards, -- Jean-Pierre Tosoni