Compare two file data row by row in SQL

115 pts.
Tags:
SQL
SQL Query
I need to compare two files (Previous data and current data) with same fields but changed in some fields value in Current sheet. I want to compare both files and filter only those records which are changed.
 Ex.
Previous Data:
Reference name Address contact
123A Jhon USA
123 123B Paul UK
457 123C Smith AUS
345 123D Ryan India 789
Current Data: Reference
name Address contact
123A Jhon USA 123
123B Paul UK 999
123C Smith Japan
345 123D Ryan India789
Result Table
Previous data (select only changed value cell with original data)
123B Paul UK 457
123C Smith AUS 345
Current Data (select only changed value cell with current changed data)
123B Paul UK 999
123C Smith Japan 345
 Need help in SQL query for the same.
 Thanks in advance
- Gautam
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: