how to make this query? Please help me

[Quoted] [Quoted] shows and dates with the following contents:

SHOWS: id name
  1 showa
  2 showb
  3 showc

DATES:

[Quoted]   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) Received on Thu Nov 25 1999 - 20:31:27 CET