Table1
-----------
C1
----------
dos
mou
com
dis
cus
ion

##</code><code>##

Table2
------------
C1
-----------
mouse
discussion
computer

##</code><code>##

mou is present in mouse
com is present in computer
dis is present in discussion
cus is present in discussion
ion is present in discussion

##</code><code>##

my $check =dbh->prepare("SELECT Table.C1, Table.C2 FROM Table1, Table2 WHERE Table.C1 LIKE Table.C2");
$check->execute();
print "rows present:" + $check->rows;
while(@rows = $query->fetchrow_array())
{
echo $row['Table1.C1'].is.present.in.$row['Table2.C2'];
}

##</code><code>##

Cant't call method "execute" on an undefined value at ./filename line 123