triplell89
Registered User.
- Local time
- Today, 08:03
- Joined
- May 21, 2009
- Messages
- 21
Hi,
First I would like to say that I know that SQL is very powerful, so this operation should be possible.
I have a table containing two ID fields: Sender, Receiver. How can I view the unique values of both fields?
The fields have the following rules:
1. 1 sender can have multiple receivers
2. 1 receiver can have multiple senders
3. A sender can also be a receiver, but not always.
4. A receiver can also be a sender, but not always.
So pretty much I have two lists, R and S. I want to combine the list, and then eliminate all the duplicates.
First I would like to say that I know that SQL is very powerful, so this operation should be possible.
I have a table containing two ID fields: Sender, Receiver. How can I view the unique values of both fields?
The fields have the following rules:
1. 1 sender can have multiple receivers
2. 1 receiver can have multiple senders
3. A sender can also be a receiver, but not always.
4. A receiver can also be a sender, but not always.
So pretty much I have two lists, R and S. I want to combine the list, and then eliminate all the duplicates.