>SELECT DISTINCT MyPk, NextField1, Nextfield2 >FROM MyTable > >etc. >Unfortunately this table has around 50 columns, so it is not practical to list them all. Also, I want the contents of the text field to appear in the final subset, and naming it explicitly still gives me the same error.