HELP! Select Stmt

I have two table :

1. Table A

	Vehicle no.


	......

[Quoted] 2. Table B

	Vehicle no.
	Operation Date 


	......

[Quoted] I need to find out all records in Table A which do not have any record in table B for each operation date. eg 1/9/01 till 30/9/01.

I have written the following stmt :

Select Vehicle_no from A minus Select Vehicle_no from B where operation date='01/09/01'

The above stmt have to be run 30 times and operation date is not shown as a column.

I have tried Select a.Vehicle_no , b.operation_date from A minus Select Vehicle_no from B where operation date='01/09/01' but it does not work ?

Many thanks for your help. Received on Wed Oct 10 2001 - 22:56:12 CEST