Xref: alice comp.databases.oracle.tools:36276
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newspeer.clara.net!news.clara.net!remarQ-uK!rQdQ!supernews.com!remarQ.com!remarQ69!not-for-mail
From: "Pete Kolton" <peter.kolton@nspmbtinternet.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: how to make this query? Please help me
Date: Fri, 26 Nov 1999 10:05:30 -0000
Organization: PS Kolton Ltd
Lines: 55
Message-ID: <81llt1$qdr$1@supernews.com>
References: <383d8d55.802997@news2.cistron.nl>
X-Trace: 943610593 4XFOGJ4LKA544D432C uk21.supernews.com
X-Complaints-To: newsabuse@remarq.com
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0

break on name;
SELECT name,showdate
from shows a,show_dates b
where a.showid = b.showid

--
========================================================
Pete Kolton
ORACLE Systems Consultant
All reasonable offers considered :-)

Pete@kolton.com
http://www.kolton.com
========================================================

Maiko wrote in message <383d8d55.802997@news2.cistron.nl>...
>I've 2 tables:
>
>shows and dates with the following  contents:
>
>SHOWS:
>
>id    name
>  1   showa
>  2   showb
>  3   showc
>
>DATES:
>
>  id     showid    date
>  1       1             25-11-1999
>  2       1             30-11-1999
>  3       2             24-11-1999
>  4       2             27-11-1999
>
>
>
>
>We want the output of a query ordered by date and grouped by showname,
>ie
>
>    showb     24-11-1999
>                    27-11-1999
>    showa      25-11-1999
>                    30-11-1999
>
>
>Please help me out, and tell me how to do this in SQL. It's very
>urgent for me so any help will be very appreciated.
>
>Thanx in advance,
>
>Maiko (maikoo@cistron.nl)