Hi,
I have to join 2 files based on two key field columns.
But join command allows to give only one key column for fetching.So kindly update me whether i can compare 2 files based on two key columns or more than one key column.If so what is the syntax to compare it.
With thanks in advance,
subra.

You can compare two files using diff, comm, cmp commands...
use man pages for further details...

if your file is large then u can also use bdiff..

Is this what you are looking for???

-Nisha

I don´t think you´re right, nisha, cause he like to join two files based on two fields and not only want´s to see the difference between those files for what you´re using the diff/compare command.
But I´ve no idea how to help - probably awk or sed should help let me have a look :-)

BRGDS

Frank

Hi,
I am specifically looking for the join command only...I've got the results from the diff utility and now i want to seperate the results obtained from it based on some conditions..So i want to know whether join can be used for more the one key column ...
with thanks
subra

Hi,
I think i did not state my query properly.This is the actual scenario....
Consider that there are two files. Each file contains data stored in a table in a database. Assume that the respective tables have primary key defined on atleast two columns. Is it possible to join the two files on these primary key columns?
with thanks in advance,
subra.

Join can only be used for only one key column - so we have to find out an other solution.

greetz,
frank

Hi,
Thanks to everyone for ur prompt replies.Can u suggest me the other solution or kindly post a reply to this query when u come across an alternative to this...
Thanks in advance,
subra