comparing data in sql

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

SQL-Server

hi
How Comparing data in two different tables to find different record ?

Posted 24-Apr-11 21:15pm

raheleh_es

Add a Solution

Comments

nagendrathecoder 25-Apr-11 3:17am

Your question is not clear, can you explain it little bit more.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-04-24T21:48:00

Solution 1

Why would you want to do that?

In order to have any chance of doing it automatically, the two tables would have to have identical definitions: every field in both tables must be exactly the same.

So why would you have two tables which are the same, and contain the same information?

You can try something along the lines of:

SQL

SELECT * FROM table1 WHERE NOT EXISTS (SELECT * FROM table2 WHERE table1.Id = table2.Id)

Posted 24-Apr-11 21:48pm

OriginalGriff

Comments

raheleh_es 26-Apr-11 0:00am

I have two tables that they have one fild to join
I need independence part of first table;

OriginalGriff 26-Apr-11 1:58am

Sorry? That doesn't make a lot of sense - can you try again, but try an example: it may may it easier to work out what you are trying to say!

raheleh_es 26-Apr-11 3:54am

select table1.* from table1,table2 where table1.Id!=table2.Id

but It repeted again

OriginalGriff 26-Apr-11 4:27am

Yes, it will. You have asked for "all records in these two tables which do not have the same iD".
i.e.: if table1 has records with iD 1, 2, 3, and table2 has records with iDs 1, 2, 3 then return:
1 2,
1 3,
2 1,
2 3,
3 1,
3 2
but not
1 1,
2 2,
3 3

Did you try what I suggested?

raheleh_es 26-Apr-11 5:40am

yes

OriginalGriff 26-Apr-11 6:15am

What happened when you tried select...where not exists...?

raheleh_es 26-Apr-11 5:46am

can you helpe me plze

thatraja · Answer 2 · 2011-04-24T21:55:00

Solution 2

You need to query the database...that's all

How to compare two tables - SQL Server[^]

The shortest, fastest, and easiest way to compare two tables in SQL Server: UNION ![^]

SQL Server 2005: Using EXCEPT and INTERSECT to compare tables[^]

Posted 24-Apr-11 21:55pm

thatraja