Help Please

Hi,

Am trying to create create an sql statement to display a list of inactive users. The Tables used are as follows



dbo.clientSession

clientSessionID, loginLocationID, personID, userRoleID, loginDate, logoutDate, expireDate, timeoutDate, ipAddress

dbo.clientUser

personID, activeInactiveFlag, username

I would like to see anyone that has no loginSession from the past 90days.

My proplem has been that each session is a new row.
I have been using the colum personID for the table link.
I have been using loginDate for the date as logoutDate can = Null
I haven't tryed somesort of subqurie, maby thats what this needs.

Any Help would be greatly helpfull. I need to get this information one way or another.