[NTLUG:Discuss] Is there an easy way?

[Michael Barnes]

On Sun, Jul 26, 2009 at 12:42 PM, Chris Cox <cjcox at acm.org> wrote:

> On Sun, 2009-07-26 at 00:06 -0500, Leroy Tennison wrote:
> > I'm not even sure how to Google for this one without having to wade
> > through too many extraneous hits so I'm posting here.  I have three
> > files and need to merge fields from each of them into a single file.  A
> > brief description of each is:
> >
> > File 1 has a phone number and an associated IP address (VOIP, Avaya PBX)
> > File 2 has an IP address and an associated MAC address (Cisco router).
> > File 3 has a MAC address and associated Cisco switch port assignment.
> >
> > I need a file containing phone number and associated switch port.
>
> man join
>
> You'll need to sort by the key field before joining files.
>
> It's like a two table join in sql.
>

Ah, the joy of Linux.  Ask three guys how to do something and get five
solutions, each of which is valid and will work, yet each totally different.

I love it.