HELP! How to check missing records

From: Ho <kowho_at_singnet.com.sg>
Date: Sat, 20 Oct 2001 23:57:46 GMT
Message-ID: <9qt69u$bcm$1@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 - 18:57:46 CDT