Select Count.*, Datacard.Listname, Selection.Selection > FROM Count JOIN ListOrder ON Count.ListID = ListOrder.ListID > AND Count.SelectID=ListOrder.SelectID > AND ListOrder.MailingOrderID=133 > JOIN Datacard ON Count.ListID = Datacard.ListID > JOIN Selection ON Count.SelectID = Selection.SelectID > WHERE Count.CountAsOf = ( > SELECT Max(CountAsOf) FROM Count Cnt > Where cnt.ListID = Count.ListID > And Cnt.SelectID = Count.SelectID ) > ORDER BY Datacard.Listname, Selection.Selection >>>Thanks a lot Sergey but I have another twist I forgot to mention which I should have. Actually, instead of using a theoretical example trying to keep it simple, I'll just provide my real problem (which I should of from the beginning).
>Select DISTINCT [Count].*, Datacard.Listname, Selection.Selection >>FROM [Count] JOIN ListOrder ON [Count].ListID = ListOrder.ListID >>AND [Count].SelectID=ListOrder.SelectID >>AND ListOrder.MailingOrderID=133 >>JOIN [Datacard] ON [Count].ListID = [Datacard].ListID >>JOIN Selection ON [Count].SelectID = Selection.SelectID >>ORDER BY Datacard.Listname, Selection.Selection >>>Sorry about making you think twice about this. TIA.