Jack Kane wrote, > One of my tables has about 140 distinct values in one column and 70 in > another column. would like to design a query that selects distinct pairs of > values, so that each pair is unique. > > If that is possible, would one of you please give me an example.
select distinct <col1>, <col2> from <table> HTH, Paul Vinkenoog