Re: sql query wanted

damorgan wrote:
>
> Look at DECODE.

what should I where decode? in the mean time I was trying to see if hierarchical queries would be helpful without results yet :-( christian

> > create table foobar (id varchar(10), sku varchar(10));
> >
> > insert into foobar values ('1', 'a');
> > insert into foobar values ('2', 'b');
> > insert into foobar values ('3', 'a');
> > insert into foobar values ('3', 'b');
> > insert into foobar values ('4', 'c');
> > insert into foobar values ('5', 'a');
> > insert into foobar values ('5', 'c');
> > insert into foobar values ('6', 'a');
> > insert into foobar values ('6', 'b');
> > insert into foobar values ('7', 'a');
> > insert into foobar values ('7', 'b');
> > insert into foobar values ('7', 'c');
> >
> > Now I have to query based on sku: I need all id's where there are row's
> > for that id with exactly the sku's provided.
> >
> > Example:
> > if I have a it should return 1
> > if I have b it should return 2
> > if I have c it should return 4
> > if I have a and b it should return 3 and 6
> > if I have a and c it should return 5
> > if I have a, b and c it should return 7
Received on Fri Feb 22 2002 - 03:40:37 CST