Re: Group By?

On Feb 8, 2:53 pm, "shakespeare" <what..._at_xs4all.nl> wrote:
> <ame..._at_iwc.net> schreef in berichtnews:1c04d8cf-f3da-4b8b-9b0d-8e451c94c762_at_h11g2000prf.googlegroups.com...
>
>
>
>
>
>
>
> > Hi All,
>
> > I have the following query.  For a few records, it returns duplicate
> > CUSTOMER_ID's, though the rest of the record values are different.
>
> > I want 1 record per CUSTOMER_ID, regardless of the other values.
>
> >   SELECT co.customer_id c_id, engine.calc_end_date (co.order_date,
> > p.quantity, p.quantity_uom) end_date,
> >          DECODE(ns.subscr_type, 'Trial', 'Trial', 'Test', 'Trial',
> > 'Paid') subscr_type
> >   FROM engine.customer_order co, engine.order_line ol, engine.product
> > p, product.newsletter_subscription ns
> >   WHERE co.order_id = ol.order_id
> >   AND ol.product_id = p.product_id
> >   AND p.code = ns.code
> >   AND p.subproduct_id IN (197, 202, 209, 216, 220, 222)
> >   AND ol.status = 'Active'
> >   ORDER BY co.customer_id;
>
> > Still working a solution.
>
> Then DON'T select the other values (if you don't care about them)....
>
> Shakespeare- Hide quoted text -
>
> - Show quoted text -

Actually I do need them, as they are used later in another query....... Received on Sat Feb 09 2008 - 12:08:55 CST