View Single Post
Old 02-20-2012, 01:58 PM   #3
MikeB
Thumbs Must Hurt
 
Join Date: Feb 2005
Location: Canada
Model: 8830
Carrier: BELL
Posts: 65
Default Re: SQL Query find Last Com. Time

I used :

SELECT US.LastContactTime, UC.MailBoxSMTPAddr, UC.CreationTime FROM UserStats US
INNER JOIN UserConfig UC ON UC.id = US.UserConfigId
ORDER BY US.LastContactTime
__________________
7 Bes Servers on Domino
4000 Satisfied Users
Offline   Reply With Quote