I would like to use a SELECT DISTINCT just over some columns in the table. Is there a way how to force "myObject.select()" method to return defined columns only? (SELECT first, second, third FROM MY_OBJECT)

I mean: "myObject.select()" is doing SELECT query over all columns in myObject  (myObject is usually defined for all columns in the table). Because of that  "myObject.select(distinct=True)" is not returning what I exactly need.

Thanks for your help


Petr Jakes