Hi

I need some help with a query/logic. I have created a program that log email rountrip time. I have got 2 Tables. The first table in inbox and the second Sent Items.

Inbox
***** Fields
Subject|Received
******
Sent Items
*****Fields
Subject|Sent
******

Subject will be the same for the mail that has been sent and the mail returned.

If I use the following it returns only mail that has been sent and received.

SELECT Inbox.Subject, Inbox.Received, [Sent Items].Sent
FROM Inbox INNER JOIN [Sent Items] ON Inbox.Subject = [Sent Items].Subject
ORDER BY Inbox.Subject

How could I query this to determine if a subject line exist in Sent Items but not in Inbox---to indicate it never came back? (More of a comparison between the tables)

Any advice/help appreciated

Regards
Marnus

Not sure if you are using MSACCESS or SQL Server.

You can use this.

SELECT [Sent Items].Subject, [Sent Items].Sent
FROM [Sent Items], Inbox WHERE [Sent Items].Subject <> Inbox.Subject
ORDER BY [Sent Items].Subject

Cheers!

_________________________
-Vijay G
Strive for Perfection

Or you could use a LEFT JOIN, this way all email's that never came back will have NULL in the [Sent Items].Sent column. Here is an example: I hope this helps.

Regards
Owain Williams

Hi

Thanks, I will give this a shot...

Marnus