|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
June 9th, 2004, 12:28 PM
|
|||
|
|||
Compare data in two tables with SQL query?
I am trying to QA data being put into a SQL database by an outside source (from Excel) and therefore need to compare two (for the sake of simplicity) tables within a database to one another.
The two tables should contain the same data, and the QA process is meant to find and report any discrepancies. The column names are slightly different. My question then is, is it possible to write a simple SQL query which will compare the data from the two tables and select only those rows where the data in any given column does not match? My data is mostly text, not numerical. I'm very new at using SQL and my knowledge of the query syntax is very basic. Thanks for any help in advance! ~Lacy
|
|
#2
July 21st, 2004, 07:11 PM
|
|||
|
|||
|
Hello Lacy. Ufortunately I can't help you. The reason I registered in this forum is because I found your question in a search engine using "compare tables with SQL". I have the same problem with you. I can't find any answer here. Did you?
|
|
#3
July 22nd, 2004, 09:51 AM
|
|||
|
|||
|
Opps - wrong forum
Last edited by jim mcnamara : July 22nd, 2004 at 09:53 AM. Reason: Posted to wrong forum.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Compare data in two tables with SQL query? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
