Hi Lowel,

Thanks for that, but I get the exact same result set as my original query.

Here are my create scripts.

https://www.dropbox.com/s/bh2ynmlsyt9o8z5/sqlScripts.zip?dl=0

I'll try explaining what I'm after again.

I want a list...

Hi,

Yes, I do need help.

My issue is:

I want a list of CustomerID, UserName, LastOrderDate, NextCallbackDate for all customers who have an record in the Order table but their last callback...

Apologies to both! I used a left outer join during my fiddling trying to figure out why some records were not showing up..

aspnet_Users table:

[dbo].[aspnet_Users](

[ApplicationId] [uniqueidentifier] NOT NULL,

[UserId] [uniqueidentifier] NOT NULL,

[UserName]...

Thanks djj.

Also, Martin, thank you very much - that seems to have worked - the only thing that is missing is the LastOrderDate in the result set as I want...

Thanks everyone for your help. Jack's solution works just great. I probably should have posted the output I wanted, but in essence I wanted it grouped by Username with the...