join 3 files by first Column with awk ?
- by noinflection
i have three similar files, they are all like this:
File A
ID1 Value1a
ID2 Value2a
.
.
.
IDN Value2n
and i want an output like this
Output
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, and so on which each field and each line. I thougth it like a sql join. I've tried several things but none of them where even close.