rasco22862
New member
- Local time
- , 20:32
- Joined
- Apr 7, 2010
- Messages
- 4
Hello, I have the following Mail table:
Id Number Type Description mailDate User
4 101 Inbox Aaaa 22/04/2010 Reception
5 102 Inbox Bbbb 22/04/2010 Reception
6 103 Inbox Cccc 23/04/2010 Reception
7 102 Received Dddd 24/04/2010 John
"Inbox" is the mail that arrives at the office, and "Received" is when the destination person actually GETS the mail. So the recepcionist enters the inbox data, and then the destination person enters the received data when he pickup the mail from the receptionist.
I want to filter all "Inbox" records that weren´t "Received". I`m cofused on how to achieve this.
Thanks!
Id Number Type Description mailDate User
4 101 Inbox Aaaa 22/04/2010 Reception
5 102 Inbox Bbbb 22/04/2010 Reception
6 103 Inbox Cccc 23/04/2010 Reception
7 102 Received Dddd 24/04/2010 John
"Inbox" is the mail that arrives at the office, and "Received" is when the destination person actually GETS the mail. So the recepcionist enters the inbox data, and then the destination person enters the received data when he pickup the mail from the receptionist.
I want to filter all "Inbox" records that weren´t "Received". I`m cofused on how to achieve this.
Thanks!