If a query returns, say the following results:<br /><br />id value<br />0 a<br />0 b<br />0 c<br
/>1 a<br />1 b<br /><br /><br /><br />How do I just choose a preferred element say value 'a' over any other
elementsreturned, that is the value returned is from a subquery to a larger query?<br /><br />Thanks.<br />