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


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

Original text of this message