Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
>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!
Works in VFP6 if you chage your code like this:
SELECT Products.*,Prices.Price ;
FROM Products
inner join Prices on Products.ID = Prices.ID ;
WHERE Prices.ID in ;
(SELECT Prices.ID,MAX(prices.effective_date) FROM Prices ;
group by Prices.ID )
Mark
Previous
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