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...