Re: how to make this query? Please help me
From: Pete Kolton <peter.kolton_at_nspmbtinternet.com>
Date: Fri, 26 Nov 1999 10:05:30 -0000
Message-ID: <81llt1$qdr$1_at_supernews.com>
Date: Fri, 26 Nov 1999 10:05:30 -0000
Message-ID: <81llt1$qdr$1_at_supernews.com>
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_at_kolton.com http://www.kolton.com ======================================================== Maiko wrote in message <383d8d55.802997_at_news2.cistron.nl>...Received on Fri Nov 26 1999 - 11:05:30 CET
>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_at_cistron.nl)