Shell Programming and Scripting

table1
table2
table3

name#place#data#select * from table1
name2#place2#data2#select * from table 10 innerjoin table3
name2#place2#data2#select * from table 10

name place table1
name2 place table3

#! /bin/ bash 
while read line           
do  
x=`echo "$line"`
awk /'$x'/ > "file"($x~/"$line"/?2:1)}' testfile.txt 
done<list.txt

awk 'NR==FNR{a[$0]; next} {for(x in a) {if($0 ~ x) {print $1, $2, x}}}' FS='#' list.txt testfile.txt

awk 'NR==FNR{a[$0]; next} {for(x in a) {if($0 ~ x) {print $1, $2, $3, x}}}' FS='#' list.txt testfile.txt

awk -F"[# ]" 'NR==FNR{a[$1]=$1;next}$NF in a {print $1, $2, a[$NF]}' list.txt testfile.txt

name2#place2#data2#select * from table3 innerjoin table 10