[prev] [index] [next]

join: database operator (cont)

Given these two data files (tab-separated fields) 

# data1:                            # data2:
Bugs Bunny      1953            Warners Bugs Bunny
Daffy Duck      1948            Warners Daffy Duck
Donald Duck     1939            Disney  Goofy
Goofy   1952                    Disney  Mickey Mouse
Mickey Mouse    1937            Pixar   Nemo
Nemo    2003
Road Runner     1949

the command join -t' ' -2 2 -a 1 data1 data2 gives 

Bugs Bunny      1953    Warners
Daffy Duck      1948    Warners
Donald Duck     1939
Goofy   1952    Disney
Mickey Mouse    1937    Disney
Nemo    2003    Pixar
Road Runner     1949