linux - Bash join command

Question

Infile1:

1 a
3 c
4 d
6 f

Infile2:

1 a 
2 b
5 e
6 f
7 g
8 h

How do I join these files with the unix join command to get this output:

1 aa
2 b
3 c
4 d
5 e
6 ff
7 g 
8 h

Dogbanes answer worked but... when I apply dogbanes answer on this file:

27  27
28  22
29  37
30  15
31  21
32  13
33  18
34  24

and this:

27  7
28  13
29  6
30  12
31  30
32  5
33  10
34  28

They don't join:

27  27
27  7
28  13
28  22
29  37
29  6
30  12
30  15
31  21
31  30
32  13
32  5
33  10
33  18
34  24
34  28

The second scenario is tab delimited so I used -t

Answer 1

Works for me (almost). You should specify -t $'' for the tab character, not just -t . Bash does not interpret unless in $'' quotes.

join -t $'' -o 1.2,2.2 <(echo  $'2727
2822
2937
3015
3121
3213
3318
3424' | sort) <(echo $'277
2813
296
3012
3130
325
3310
3428' | sort)
27      7
22      13
37      6
15      12
21      30
13      5
18      10
24      28