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']; }