for (my $i=0; $i<=$#id; $i++){ my $sth=$dbh->prepare("SELECT Data,Identifier,User,Version FROM ddts,delivery WHERE `User`=\"@user\" AND `Identifier`=\"$id[$i]\" AND delivery.Data=ddts.Data"); $sth->execute(); while (my ($data,$identifier,$user,$version)=$sth->fetchrow_array ) { print " $identifier";} if ($id[$i] ne $identifier){ print " $id[$i]"; } $sth->finish; }