my $counter = 0; while (@ary = $sth->fetchrow_array ()) { if ($ary[$counter] == NULL){ print join("\t",@array[$counter]), " ","\n"; $counter++; } else { print join("\t",@array[$counter]), $ary[$counter],"\n"; } $counter++; }