Mailsweeper SQL graphical query tool - point to point..

[Stat1c]

MLHSE here u go...
SELECT goaEngineDetail.StartTime, RecipientMap.MappedValue, SenderMap.MappedValue,
moaMessage.Subject, moaMsgIDMap.MappedValue,moaMessage.MsgSize,goaCategoryMap.MappedValue

FROM (((((moaMsgIdMap moaMsgIdMap
INNER JOIN moaRecipients moaRecipients ON moaMsgIdMap.MapID = moaRecipients.MapID)
INNER JOIN moaMessage moaMessage ON moaMsgIDMap.MapID = moaMessage.ID)
INNER JOIN goaEngineDetail goaEngineDetail ON moaMsgIdMap.MapID = goaEngineDetail.ID )
INNER JOIN moaAddressMap SenderMap ON moaMessage.Sender = SenderMap.MapID )
INNER JOIN moaAddressMap RecipientMap ON moaRecipients.MappedValue = RecipientMap.MapID )
INNER JOIN goaCategoryMap goaCategoryMap ON moaMessage.Category = goaCategoryMap.MapID

WHERE SenderMap.MappedValue LIKE '@hotmail%'
AND RecipientMap.MappedValue LIKE '%lycos.com'
AND goaEngineDetail.StartTime like '%sep%1%2001%'

ORDER BY goaEngineDetail.StartTime ASC, moaMessage.Sender ASC, moaRecipients.MappedValue ASC, moaMsgIDMap.MapID ASC

STAT1c