Re: HELP! How to check missing records

Hi !

[Quoted] This task may be done in sql, but the computing clause is not quite simple and fast...

[Quoted] 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.

[Quoted] "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 Mon Oct 22 2001 - 17:46:29 CEST