Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> HELP! Select Stmt
I have two table :
Vehicle no.
......
2. Table B
Vehicle no. Operation Date
......
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 - 15:56:12 CDT