Re: Gray Hair is still relevant

> "Let's say I have a table of users, and each user has a list of categories....get a full list of everyone's categories without duplicates.

Below is how a dummy could do it:

(new 'cat)

(new 'john)
(create john cat (val+ 'person))

(new 'mary)
(create mary cat (val+ 'person))
(create mary cat (val+ 'engineer))

(new 'bob)
(create bob cat (val+ 'person))
(create bob cat (val+ 'engineer))
(create bob cat (val+ 'pilot))

(; Following query returns person, engineer and pilot without
duplicates)
(select cat instance *)

See www.dbfordummies.com for more details. Received on Mon Jul 10 2006 - 01:14:24 CEST