Hi Folks,

I posted this problem several days ago and removed ti when I thought I
had it licked. oops.

I need all information from tbl1 and the LATEST or highest
PropertyPriceID with the attached PropertyPrice.

I have spent DAYS on this now and am utterly stumped.
The best Query I have come up with is at the bottom and I have gotten
everytiing but the PropertyPrice value.

ASP on a mySQL database version 4.1.10

Two tables
tbl1 Properties
PropertyID
PropertyAddress
PropertyCity
PropertyState
PropertyZipCode

tbl2 PropertyPrice
PropertyID
PropertyPriceID
PropertyPrice





SELECT Properties.PropertyID, Max(PropertyPrice.PropertyPrice) AS
MaxOfPropertyPrice, Properties.PropertyAddress,
Properties.PropertyCity, Properties.PropertyState,
Properties.PropertyZipCode
FROM Properties INNER JOIN PropertyPrice ON Properties.PropertyID =
PropertyPrice.PropertyID
GROUP BY Properties.PropertyID, Properties.PropertyAddress,
Properties.PropertyCity, Properties.PropertyState,
Properties.PropertyZipCode
ORDER BY Properties.PropertyID;