Re: URGENT Join question

From: Noel <tbal_at_inchrosoft.com.pl>
Date: Mon, 13 Aug 2001 17:01:55 +0200
Message-ID: <3b77ea1e_at_news.vogel.pl>


I suggest you to use "MINUS" clause.

for example :

 select col1 from table2
 minus
 select col1 from table1

Should return no rows.

Uzytkownik "Manoj Nair" <debo_nair_at_yahoo.com> napisal w wiadomosci news:92a0e580.0108081623.651e99a5_at_posting.google.com...
> 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
Received on Mon Aug 13 2001 - 17:01:55 CEST

Original text of this message