Shell Programming and Scripting

Try below shell script..

#! /bin/ksh
#set -vx
INFILE1=$1
INFILE2=$2
OUTFILE=/tmp/outfil.dat
cat $INFILE1 | while read line
do
cat $INFILE2 | while read line1
do
echo $line
wrd=`echo $line1 | cut -c1-24`
if [ $line = $wrd ]; then
echo $line1 >> $OUTFILE
fi
done
done

======================================================
$cat f1.dat
QWERTYUI098765432112345
QWIUYTUI098765432112345
CDXRTYUI098765432112345

$cat f2.dat
QWERTYUI098765432112345 abc@soft.com 2007-09-260012275.80 0000924 00245.00 2007-
10-25ASDFRESS,POIU S 000000000000015.52 000000000000000.00 CBB00010000000906
QWERTYUI098765432112345 abc@soft.com 2007-09-260012275.80 0000924 00245.00 2007-
10-25ASDFRESS,POIU S 000000000000015.52 000000000000000.00 CBB00010000000906
QWERTYUI098765432112345 abc@soft.com 2007-09-260012275.80 0000924 00245.00 2007-
10-25ASDFRESS,POIU S 000000000000015.52 000000000000000.00 CBB00010000000906
AAQAAAAAAAAAAAAAAAAAAAA abc@soft.com 2007-09-260012275.80 0000924 00245.00 2007-
10-25ASDFRESS,POIU S 000000000000015.52 000000000000000.00 CBB00010000000906
$

$comp.ksh f1.dat f2.dat

$view /tmp/outfil.dat
QWERTYUI098765432112345 abc@soft.com 2007-09-260012275.80 0000924 00245.00 2007-
10-25ASDFRESS,POIU S 000000000000015.52 000000000000000.00 CBB00010000000906
QWERTYUI098765432112345 abc@soft.com 2007-09-260012275.80 0000924 00245.00 2007-
10-25ASDFRESS,POIU S 000000000000015.52 000000000000000.00 CBB00010000000906
QWERTYUI098765432112345 abc@soft.com 2007-09-260012275.80 0000924 00245.00 2007-
10-25ASDFRESS,POIU S 000000000000015.52 000000000000000.00 CBB00010000000906

==============================================

Hope this helps

nivas
(1) sort the first field of file1
(2) same way sort the second file on the first field
(Assuming the first field's record length is same if digit is there use sort -n
if strings is there use sort -d and if both are there use sort -k , and you want to join on the first field.)
use the comd ->
join -1 1 -2 1 -t(the delimiter used ) -o 1.1 1.2 2.1 2.1 file1 file2 > file 3
Here 1.1 is the first filed of file1 and likewise .I hope it I have made it
clear .

Enjoy