How to do a join of 3 files with awk by first Column?
- by noinflection
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.