How would you phrase a CREATE statement to state the following...
I have 2 columns, each column can have duplicate values, but no rows can have both duplicated...hrm..example:
| I1| I2| Data
| 1 | 2 | Data
| 1 | 3 | Data
| 2 | 2 | Data
| 3 | 1 | Data
| 3 | 2 | Data
but I could not add (1 | 3) again. I1 and I2 are the keys in this example. I've been searching the internet for a response to this but keep coming up with syntax formats and whatnot. I would prefer a plain english response
Thanks in advance...