Home » SQL & PL/SQL » SQL & PL/SQL » Compare 2 tables
Compare 2 tables [message #19115] Thu, 28 February 2002 13:24 Go to next message
Rm69
Messages: 39
Registered: January 2002
Member
l have two tables which l want to compare
ie Tab A has col 1,col 2 col 3 tab B has the same columns. l want to write a procedure or query that will compare the two tables to match the records in each table and write out the ones that do not match into a table. How do l do that

Report message to a moderator

Re: Compare 2 tables [message #19119 is a reply to message #19115] Thu, 28 February 2002 14:43 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
create table c as
  select *
    from a
  minus
  select *
    from b
  union
  select *
    from b
  minus
  select *
    from a;

Report message to a moderator

Previous Topic: Re: Return boolean checking condition in multiple records
Next Topic: Re: Update ****Return boolean checking condition in multiple records ***
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 07 21:10:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.