Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT Join question

Re: URGENT Join question

From: Randi Wølner <randiwolner_at_hotmail.com>
Date: Thu, 9 Aug 2001 13:05:06 +0200
Message-ID: <9ktqph$6rj$1@oslo-nntp.eunet.no>

I'm not really sure I understand what you want, but if it is what I think, then using minus would be a good idea:

select * from b
minus
select * from a

Randi W.

Manoj Nair <debo_nair_at_yahoo.com> wrote in message news:92a0e580.0108081623.e512163_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 Thu Aug 09 2001 - 06:05:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US