# Table name: levels
level_id    level_name
1           Secondary One
2           Secondary Two
3           Secondary Three
4           Secndary Four

##</code><code>##

# Table name: profiles
member_id
level_id
dob
.
.
.
joined

##</code><code>##

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}

##</code><code>##

# In a separate file from the main script
our %levels = (
  1 => Secondary One,
  2 => Secondary Two,
  3 => Secondary Three,
  4 => Secndary Four
);

##</code><code>##

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}}