-
Comparing Two Tables
Hi Dear,
This Code will compare Two Tables.
And Filter Records from Table1 which R not existing in Table2. I think will help out.
SELECT A.COL1,
A.COL2,
A.COL3,
A.COL4
FROM (SELECT COL1,COL2,COL3,COL4 FROM Table1) A
LEFT OUTER JOIN
(SELECT COL1,COL2,COL3,COL4 FROM Table2) B
WHERE (CASE WHEN A.COL1 = B.COL1 THEN 1 ELSE 2 END) = 2
Thanks & Regards
Bhudev Prakash
-
sync procedure to compare and update 2 tables
Can you please advice me on what script should I use to sync procedure to compare and update 2 tables.
So basically i need two sync parts: First is INSERT of what is not yet existing, second one is UPDATE on the appropriate attributes
how would i go about doing that.
Please advice.
Sincerely,
parikhm3.
-
-
Rdbms
what do you mean by what RDBMS
-
Which database system? Oracle, MS SQL or else?
-
-
Do you need to update data or table schemas?
-
Do you have table schemas? You need sync tables based on whick column?
-
use tablediff utility.
http://www.databasejournal.com/featu...le.php/3594926
or
use 3rd party products like SQLCompare.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|