I have a query that provides a lookup for possible sections within an Orchard but it's driven by row so I get multiple results; how do I get results for just the sections possible? Is there a hide duplicate way in a query? Thanks for any help!
Single Value Lookup
- Thread starter ssworthi
- Start date
boblarson
Smeghead
- Local time
- Today, 02:52
- Joined
- Jan 12, 2001
- Messages
- 32,040
I have a query that provides a lookup for possible sections within an Orchard but it's driven by row so I get multiple results; how do I get results for just the sections possible? Is there a hide duplicate way in a query? Thanks for any help!
Either use Select DISTINCT or use a GROUPING query.
But the question means that you are storing the same data over and over again where it should be in another table and then you select the values from there as options but store the ID instead.
Similar threads
