Re: [SQL] enumerate groups given a certain value

2008-08-07 Thread Yura Gal
Hello, Picavet. > Anybody for a ray of light on a different approach ? This look like a > recurrent problem, isn't there an experienced sql programmer here who > tackled this issued a couple of time ? Actually, I'm not very experienced in SQL. But from my point of view this problem could be solve

[SQL] enumerate groups given a certain value

2008-08-07 Thread Picavet Vincent
Hello, Here is a sql problem, which I thought simple at first, but for which I ended up with a solution I find surprisingly complicated. I really think I could have achieved a much easier way of handling this, but I do not manage to find the trick allowing a very simple and efficient query to solv