One more try with that query. sorry. It's still $50. select distinct field1 from table1 order by field1 ^ makes first list select field2 where table1.field1 = result from that selection