Shell Programming and Scripting

aaa 20 22 apple
aaa 18 25 banana
aaa 12 30 grapes
aaa 22 25 melon

aaa 18 26 cdded
aaa 10 35 abcde

aaa 18 26 cdded banana melon  
aaa 10 35 abcde apple  banana grapes melon

aaa 18 26 cdded apple banana melon  
aaa 10 35 abcde apple  banana grapes melon

awk '
        NR == FNR {
                A[$NF] = $0
                next
        }
        {
                for ( k in A )
                {
                        split ( A[k], V )
                        if ( $2 >= V[2] && $3 <= V[3] )
                        {
                                T[k] = T[k] ? T[k] OFS $NF : A[k] OFS $NF
                        }

                }
        }
        END {
                for ( k in T )
                        print T[k]
        }
' file2 file1

awk     'NR == FNR      {MIN[$4]=$2; MAX[$4]=$3; next}
                        {for (i in MIN)
                           if (MIN[i] >= $2 && MAX[i] <= $3) $0=$0" "i}
         1
        ' file1 file2
aaa 18 26 cdded apple melon banana
aaa 10 35 abcde grapes apple melon banana