General information
Category:
Coding, syntax & commands
Then, I'm not sure I understand your question.
> I want all of the newest records and ignore older matching records
Please define "newest records" (since a given date or since the last query?).
And what do you mean by "matching records"? Are two or more tables involved?
>Thanks for the idea, but not quite what I had in mind. I want all of the newest records and ignore older matching records (matching on MailingListId and ListSelectId)
>
>>SELECT TOP 10 MailingListId, ListSelectId, ;
>> StateCountAsOF, ;
>> StateCountId ;
>> FROM StateCount ;
>> INTO CURSOR zStateCount;
>> ORDER BY StateCountAsOf DESC
>>
>>HTH
>>
>>>I'm trying to use the following SELECT to get me the most current record(s) from my table based on the DateTime field StateCountAsOf.
>>>The field StateCountId is the Key field for each record.
>>>
>>>SELECT MailingListId, ListSelectId, ;
>>> MAX(StateCountAsOF) AS StateCountAsOF, ;
>>> StateCountId ;
>>> FROM StateCount ;
>>> GROUP BY MailingListId, ListSelectId ;
>>> INTO CURSOR zStateCount
>>>
>>>When I run my SELECT I get the most current date but the field ListSelectId (which is a key into another table is for another record). I tried GROUP BY MAX(StateCountAsOf) and HAVING BY MAX(StateCountAsOf) but get syntax errors. I can't use StateCountId in my GROUP BY because I then get all records (since it is the key field).
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