How to do a join of 3 files with awk by first Column?

Posted by noinflection on Stack Overflow See other posts from Stack Overflow or by noinflection
Published on 2010-05-12T04:00:07Z Indexed on 2010/05/12 4:04 UTC
Read the original article Hit count: 379

Filed under:
|
|
|

i have three similar files, they are all like this:

ID1 Value1a
ID2 Value2a
  .
  .
  .
IDN Value2n

and i want an output like this

ID1 Value1a Value1b Value1c
ID2 Value2a Value2b Value2c
.....
IDN ValueNa ValueNb ValueNc

Looking to the first line i want value1A to be the value of id1 in fileA, value1B the value of id1 in fileB, etc, i think of it like a nice sql join. I've tried several things but none of them where even close.

© Stack Overflow or respective owner

Related posts about bash

Related posts about awk