Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!cpk-news-hub1.bbnplanet.com!paloalto-snf1.gtei.net!news.gtei.net!mawar.singnet.com.sg!not-for-mail
From: kowho@singnet.com.sg (Ho)
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools
Subject: HELP! Select Stmt
Date: Wed, 10 Oct 2001 20:56:12 GMT
Organization: Singapore Telecommunications Ltd
Lines: 35
Message-ID: <9q2ftd$b3e$2@coco.singnet.com.sg>
NNTP-Posting-Host: ts900-2617.singnet.com.sg
X-Newsreader: Forte Free Agent 1.0.82
Xref: easynews comp.databases.oracle.misc:70156 comp.databases.oracle.tools:45388
X-Received-Date: Wed, 10 Oct 2001 14:51:30 MST (news.easynews.com)


I have two table :

1. Table A 

	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.