Join Or Subquery Problem

I have a query problem that baffles me.

I have one data table (tblPresultPeriods) and one lookup table (lkpStatus).

The query is:

select PPPeriodNumber as PeriodNumber, Max(PPstatus) as Status
from tblPresultPeriods
where ppmemberid = 133 and pptransseq > 0
group by ppperiodnumber

It returns (correctly):

PeriodNumber Status
------------ ------
A1 1
Q1 4
Q2 1


I want to do a join so that I get the lkpStatus.StatusDescription value to display.

The query is:

select PPPeriodNumber, Max(PPstatus)as status, StatusDescription
from tblPresultPeriods, lkpStatus
where tblPresultPeriods.PPstatus = lkpStatus.Statuscode
and ppmemberid = 133
and pptransseq > 0
group by PPPeriodNumber, PPstatus, StatusDescription
order by PPPeriodNumber, PPstatus, StatusDescription

but I get (not what I want):

PPPeriodNumber status StatusDescription
-------------- ------ --------------------------------------------------
A1 0 Initialize
A1 1 Enter Presults
Q1 0 Initialize
Q1 1 Enter Presults
Q1 4 Re-Review Presutls
Q2 0 Initialize
Q2 1 Enter Presults


because the of the additional group by & order by columns.


I assume this requires a sub-query, but I am baffeled.

Bobby