| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: Query problem
Hi,
Try this,
SELECT b.ID FROM A, B
WHERE a.id(+) = b.id AND a.id IS NULL
UNION
SELECT a.ID FROM A, B
WHERE b.id(+) = a.id AND b.id IS NULL
UNION
SELECT a.ID FROM A, B
WHERE b.id = a.id
Good luck
Zbigniew Sliwa
Oracle Programmer
Poland
email: zibi_at_at_yahoo.com
Bastiaan Schaap napisa³(a) w wiadomo¶ci: ...
>Hi all!
>
>I have a little query problem which I find very difficult to solve, I'm
more
>of a plsql man ;-)
>
>Here it is: Say I have to tables A and B both with a column e.g. ID. Now I
>want to compare these tables. In order to do that I want to do a select
that
>joins these two tables, and creates a result for every row in A and every
>row in B. Ergo: if A.ID exists and B.ID doesn't, I want to see a row for
>it. Same is for B, if B.ID exists but A.ID doesn't I also want to see a row
>in the result set. I want it to be one statement... The 'truth table' for
>this would be :
>A: B: row in resultset:
>0 0 0 (does not occur, but I'll give it anyway..)
>1 0 1
>0 1 1
>1 1 1
>
>Where a zero indicates that no row was found for the ID.
>
>Actually theoretically this works:
>SELECT A.ID as old_id, B.ID as new_id FROM A, B WHERE a.id(+) = b.id(+);
>
>However Oracle doesn't support this. Does anyone know a solution for this
>(little?) problem??
>
>Thanx,
>
>Bastiaan Schaap
>Oracle web development,
>Desyde BV - Baarn
>http://www.desyde.nl/
>tel. +31355411711
>
>
>
>
Received on Thu Aug 10 2000 - 00:00:00 CDT
 |
 |