my $sql = qq{ SELECT * FROM profiles, levels WHERE member_id=23 AND profiles.level_id=levels.level_id }; my $sth = $dbh->prepare($sql); $sth->execute(); my $hashref = $sth->fetchrow_hashref(); # So level name is stored in $hashref->{level_name}