General information
Category:
Coding, syntax & commands
Harold,
Here's how it works...
By having a sub-select statement, it is doing a test recurrsively for each primary record.
Basically asking on an EACH RECORD basis
Give me all fields I am listing from the table
PROVIDED THAT the AsOfDate on this record
IS the same date as the maximum possible date returned from the sub-select.
The sub-select is based on the same mailing list ID thus limiting the scope.
Glad it worked for you...
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