Re: SQL QUESTION: PLEASE HELP!!!!

In article <30j1p3$hc_at_crocus.csv.warwick.ac.uk>, cudau_at_csv.warwick.ac.uk (Hank Robinson) writes:
>
 

> This looks a bit messy, but this is my best shot...

[info deleted so newsreader won't choke]

>
> Select A.Ticket_Number "first of group" <<< needs comma here (little nit)
> B.Ticket_Number "last of group"
> From X A,
> X B

needs where a.ticket_status <= b.ticket_status

   and ...

> Where A.Ticket_Status Is Null And

Cool solution ...

>
> > Thank's!
>
> You're welcome. Hope this helps.
>
> > Jean-Marc Boivin
> > Universite Laval
> > Quebec city, Canada
> > mail: jm_boivin_at_cti.ulaval.ca
> > phone: 418-656-3632
>
> Hank Robinson.
> Oracle DBA,
> University of Warwick.

Terry Greenlaw
z50816_at_mip.lasc.lockheed.com Received on Thu Jul 21 1994 - 19:22:30 CEST