Need more info...what's the server version ?
am I to assume driver-id and vehicle-id make up the PK ???
"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 Sat Oct 20 2001 - 22:07:11 CDT
