Hello. I have 2 columns order_no and item_no. Duplicates are allowed in each column separately, however I would like to remove all duplicate "pairs" of order_no and item_no. So for instance (order_no, item_no) -> [(1, 4) and (1, 4)] would be deleted, but [(1, 3) and (1, 4)] OR [(1, 3) and (2, 3)] would be be allowed. Basically my primary key is the superkey of both order_no and item_no which is why I can't have duplicates. The 2 columns are right next to each other (order_no is column C, item_no is column D).

Thanks!
[kyle]