Home -> Usenet -> comp.databases.oracle -> Help with SQL Syntax

Help with SQL Syntax

From: marianne.g.pittorino <gerette_at_cbnewsb.cb.att.com>
Date: Fri, 4 Dec 1992 20:23:32 GMT
Message-ID: <1992Dec4.202332.21512_at_cbfsb.cb.att.com> 







Dear Oraclers:


I need some help with SQL syntax.  I have two tables with identical formats.
Let's call the first table FIRST and the second table SECOND.  The data in
the two tables usually match, with a few rows being different.  FIRST has
an "old" version of data and SECOND has the "new" version.



I need an SQL statement that will select the rows in FIRST that do not
match any row in SECOND (and vice versa).  For example, let's pretend we have
the following data:

	FIRST			SECOND
	-----			------
	1111			1111
	2222			2222
	3333			4444
	5555			5555





I need to know that 3333 exists in FIRST but not in SECOND, and that 4444
exists in SECOND but not in FIRST.  I do not need to know this in the same
SQL statement.



Does anyone know how to do this?



Marianne G. Pittorino
Received on Fri Dec 04 1992 - 21:23:32 CET












Original text of this message