in reply to DBI, mysql, SELECT with JOIN and field names

do you NEED the table.columname? else above idea would work, or either use fetchall_arrayref.
my $ary = $sth->fetchall_arrayref; foreach my $row (@{$ary}) { $blah = @{$row}[0];
etc.