comrade, did you check to see if this works ?????
"news.sovintel.ru" <valera_at_ivkplcrd.msk.u> wrote in message
news:9r1epp$17q9$1_at_josh.sovintel.ru...
> Hi !
>
> This task may be done in sql, but the computing clause is not quite simple
> and fast...
>
> For ex. you can write something like that:
>
> select
> distinct
> t0."Driver-ID",
> t1."Trip-No"
> from
> Trips t0,
> (select rownum "Trip-No" from user_tables where rownum < 10) t1
> where
> not exists (select NULL from Trips t2 where t0."Driver-ID"=t2."Driver-ID"
> and t2."Trip-No"=t1."Trip-No")
> /
> Regards !
> Valery.
>
>
> "Ho" <kowho_at_singnet.com.sg> wrote in message
> news:9qt69u$bcm$1_at_clematis.singnet.com.sg...
> > Hi ,
> > I need to check the missing records (trip no.) of the following table:
> >
> > Driver-ID Vehicle-ID Trip No.
> >
> > ABC 1234 1
> > 3
> > 5
> > 6
> >
> > BCD 2345 1
> > 2
> > 1 5
> > ....
> >
> >
> > For driver ABC mssing record are trip no 2 & 4, for driver BCD the
> > missing records are 3 & 4.
> >
> > How to achieve this. Can it be done through SQL ?
> >
> > Many thanks for your help in advance.
> >
> >
> >
>
>
Received on Tue Oct 23 2001 - 11:08:21 CDT
