>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.
Insanity: Doing the same thing over and over and expecting different results.