Posted by Simon Bridgewater on 09/25/05 21:42

if you only want an array with the id
then

SELECT distinct(id) FROM the_table where type='whatever';

"CyberDog" <milan-SPAM-@cdnforum.com> wrote in message
news:dh6o5c$q0q$1@ss405.t-com.hr...
> Hello!
>
> I have an tatable with records defined by 3 values, let's call them
> "id", "name" and "type".
>
> Now, I need to call all the records of one type, group them by the ID
> value, and put only one of the same ID in an array, how to pull this off
> without loops and easy on the load?
>
> Thank you in advance!

[Back to original message]