Compare Data between two table

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

can you have multiple people called Jone in your tables? if so is the code the same in tableA and tableB for the right name?

SELECT

A.Code,

A.Name,

A.Sector,

B.Sector

FROM

tableA A

INNER JOIN

tableB B

ON

A.Code = B.Code

AND

A.Name = B.Name

WHERE

A.Sector <> B.Sector

mohamed_sobhy565 SSC Rookie Points: 41 More actions · Answer 2

thanks for help me

i need to know this field only but

this table contain more from one field

Example1:

tableA

code name sector department

1 Jone 1 10

tableB

code name sector department

1 Jone 1 30

get field department only

Example2:

tableA

code name sector department

1 Jone 1 10

tableB

code name sector department

1 Jone 3 40

get fields sector and department only

zsafakhah SSC-Addicted Points: 441 More actions · Answer 3

hello Dear,

you can use AppexSQLLog for Compare data in 2 table and find difference beteen.

Best Regards,

zohreh

mohamed_sobhy565 SSC Rookie Points: 41 More actions · Answer 4

thanks zohreh

but i will use this script in my project (exe)

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

SQL Server has a TABLEDIFF.exe that you may use to compare objects, check BOL for more info

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉