>>>>>>>>>>>>>>>> Forgive my lack of formatting, every time I want to format code on the UT, I can never find any document listing the tags. >>>>>>>>>>>>>>>>>
All you need is < PRE > tags:
SELECT Products.*,Prices.Price ;
FROM Products
inner join Prices on Products.ID = Prices.ID ;
and Prices.IDin ;
(SELECT Prices.ID,MAX(prices.effective_date) FROM Prices ;
groupby Prices.ID )
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry