Shell Programming and Scripting

select * from table1 a ,table2 b
 where a.column1=b.column1;
 
select * from table1 a ,(select * from table1 c ,table2 d where c.column1=d.column1) e 
where a.column2=e/column2 ;

awk '$0 ~ /^select/ {for (i=1;i<=NF;i++)if($i ~ /table/)cnt++;print "select",j+1,": ",cnt;cnt=0;j++}' a.sql

while read tabname
do
awk -v table=$tabname '$0 ~ /^select/ {for (i=1;i<=NF;i++)if($i ~ /table/)cnt++;print table,":select ",j+1,"has: ",cnt;cnt=0;j++}' a.sql
done < tablenames