Get unique values

Ram Prashanth

New Member
I have a smart select in a sdv which is connected to a sdo (relations table in sports2000.db)

How do I get unique relation values from sdo to this smart select.
All the dynamic functions setquerywhere, assignqueryselection just allow us to modify where clause, But I can't think of a condition to add in where clause to get unique values.

I know using break-by and first-of we can get unique results, But I am not sure how to add these conditions to override sdo's query.

Can anyone please help me on this?