Home » RDBMS Server » Server Administration » Re: Rows in one table not in another -Real Urgent
Re: Rows in one table not in another -Real Urgent [message #373804] Thu, 10 May 2001 14:18
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
this is the general idea, I'm sure you can work out all the details.
select * from t1
where (a, b, c, d) in (
select a, b, c, d from t1
MINUS
select a, b, c, d from t2)

To get a row by row difference between 2 tables:
select * from t1 MINUS select * from t2

Don't forget to consider the inverse too:
select * from t2 MINUS select * from t1
Previous Topic: JSP / Oracle / SQL / Javascript / Form
Next Topic: Re: Rows in one table not in another -Real Urgent
Goto Forum:
  


Current Time: Mon Dec 23 09:36:33 CST 2024