I am trying to perform a join on two separate files. They are essentially look-up tables with a common key in the first field. It seems to only be matching the first row of one of the files. Any ideas?
Contents of file1: INT9 00:11:25:fe:ab:c6 INT3 00:14:5e:1d:bb:c2 INT1 00:14:5e:1d:cb:0e Contents of file2: INT1 10.40.21.1 INT2 10.40.21.2 INT3 10.40.21.3 INT4 10.40.21.4 INT5 10.40.21.5 INT6 10.40.21.6 INT7 10.40.21.7 INT8 10.40.21.8 INT9 10.40.21.9 Join syntax: join file1 file2 Results: INT9 10.40.21.9 00:11:25:fe:ab:c6 Desired results in no particular order: INT9 10.40.21.9 00:11:25:fe:ab:c6 INT3 10.40.21.3 00:14:5e:1d:bb:c2 INT1 10.40.21.1 00:14:5e:1d:cb:0e -- Shawn Hood (910) 670-1819 Mobile -- TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ : http://trilug.org/faq/ TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
