>>Hi All
>>
>>Forgive my lack of formatting, every time I want to format code on the UT, I can never find any document listing the tags.
>>
>
>hit reply to see the tags i've used for this response.
>
>>SELECT Products.*,Prices.Price ;
>>FROM Products
>>inner join Prices on Products.ID = Prices.ID ;
>
>change up this part of the query a bit (assuming numeric id field)
>
>>and Prices.ID in ;
>>(SELECT Prices.ID,MAX(prices.effective_date) FROM Prices ;
>>group by Prices.ID )
>>
>
>to

and transform(prices.id)+dtos(prices.effective_date) in ;
>  (select transform(prices.id)+dtos(max(prices.effective_date)) ;
>    from prices group by prices.id)

and see if that works for you.

note: this was done in VFP 6 SP3 - so 7 should be able to do this