Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
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!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only