From: debo_nair@yahoo.com (Manoj Nair)
Newsgroups: comp.databases.oracle.server
Subject: URGENT Join question
Date: 8 Aug 2001 17:23:32 -0700
Organization: http://groups.google.com/
Lines: 26
Message-ID: <92a0e580.0108081623.e512163@posting.google.com>
NNTP-Posting-Host: 64.14.248.62
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 997316612 14095 127.0.0.1 (9 Aug 2001 00:23:32 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 9 Aug 2001 00:23:32 GMT


I have 2 tables 

Table 1
col 1 varchar2
col 2 numeric

Table 2
col 1 varchar2
col 2 numric

Table 1 data
HELLO WORLD      1
HELLO WORLD NOW  1

Table 2 data
HELLO WORLD	 1

when i run 

select distinct b.col1,b.col2  from table2  b , table1 a where b.col1
<> a.col1  	  	and a.col2 = b.col2  I want no records to be returned
cos HELLO WORLD is already present in table 1..

however it returns  HELLO WORLD NOW  1 

Thanks