Mike,

As others have pointed out, use < pre > and < code > (without spaces). If you're new at it, use the preview button before posting. That has saved me a lot when I've forgotten the < /pre > or the < /code > ;-).

< hr >, < b >, and < i > work here, as well as < font color = "cMyColor" > and < font size = nMySize >.


>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.
>
>SELECT Products.*,Prices.Price ;
>FROM Products
>inner join Prices on Products.ID = Prices.ID ;
>and Prices.ID in ;
>(SELECT Prices.ID,MAX(prices.effective_date) FROM Prices ;
>group by Prices.ID )
>
>And yes, I know I can do this in 2 queries...
>
>Thanks!