my $sql = qq{ SELECT * FROM profiles, levels WHERE member_id=23 }; my $sth = $dbh->prepare($sql); $sth->execute(); my $hashref = $sth->fetchrow_hashref(); So level name can be retrived via $levels{$hashref->{level_id}}