[Q, theory] how to write complicated query?
From: Igor M. Klinchin <karmen_at_whale.sunbay.crimea.ua>
Date: 1996/09/11
Message-ID: <516j34$da8_at_ark.cris.crimea.ua>#1/1
pkey,
name
pkey,
Date: 1996/09/11
Message-ID: <516j34$da8_at_ark.cris.crimea.ua>#1/1
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 Received on Wed Sep 11 1996 - 00:00:00 CEST