Re: [Q, theory] how to write complicated query?
From: Steve Dodsworth <Steven_Dodsworth_at_qsp.co.uk>
Date: 1996/09/13
Message-ID: <51be4u$3q3_at_orion.qsp.co.uk>#1/1
Date: 1996/09/13
Message-ID: <51be4u$3q3_at_orion.qsp.co.uk>#1/1
In <516j34$da8_at_ark.cris.crimea.ua>, karmen_at_whale.sunbay.crimea.ua (Igor M. Klinchin) writes:
>Hi, folks!
>
>We have one problem and not understand now is this an our problem
>or the real problem. So two tables
>
>Master
>------
>pkey,
>name
>
>Detail
>------
>pkey,
>fkey_master references master(pkey),
>num number -- some positive integer
>
>We need select all pkey's from Master grouping them by
>name
>and equal sets of Detail.num.
>
>We are interested not only with particular solution using
>native oracle methods but with solution using standard SQL.
>
>With best wishes,
>
>dk
>
I'm not quite sure what you require, could you post some small data and required output examples
Bye,
Steve
| any similarity 'tween my opinions and that | | of my employers are purely hypothetical | | and should give no cause for alarm | --------------------------------------------Received on Fri Sep 13 1996 - 00:00:00 CEST