my $sth=$dbh->prepare( "SELECT Data,Identifier,User,Version FROM ddts, ". "delivery WHERE `User`=\"@user\" AND `Identifier`= ?" . " AND delivery.Data=ddts.Data"); foreach $id (@id){ $sth->execute($id); my $found = 0; while (my ($data,$identifier,$user,$version)=$sth->fetchrow_array ) { print " $identifier"; $found = 1; } unless ($found){ print " $id[$i]"; } } $sth->finish;