Folks,

As i don't want the users who loged in last 90 days. I want the uesr list who did not loged in in last 90 days.

Also the tbl_PBN_debugging table...

Hey Chris!!!

Hope you Doing Well..

Nways..

Yes i have tried your Code but it is giving 948 rows and which is Incorrect.

As if i only execute the query :

select max(Logdate) As LogDate,UserName

...

Thanks For Your Help but ..

As i can not make a joins on UserID because UserId filed is not present in table tbl_PBN_debugging.

In tbl_PBN_debugging there is only UserName and LogDate...