User Profile

PNair · Dec 27 '13, 04:23 PM

Here is my query. I had to make some edits to remove the table name and field name, but the structure is same.

As you can see, I am doing a SELECT *, which will give me all rows which has a mismatch. I cannot know which of the 3 conditions failed.

Code:

SELECT * 
FROM   TABLE1 PD 
       INNER JOIN TABLE2 PM 
               ON PM.KEY = PD.KEY 
WHERE  PM.FIELD1 <> PD.FIELD1 
    OR PM.FIELD2

...

PNair · Dec 27 '13, 02:21 AM

Thanks for the quick response. I will research on UNION and figure out how to use it. Meanwhile, if you have a sample query, could you pls share? Or makeup a simple SQL with one field. that would help.

Thanks again,

PNair · Dec 26 '13, 11:58 PM

I tried that, but if i do that, i will not know which row or which field has the mismatch, unless i got line by line. Let me try to explain with the example below:

Table1 Fld 1 Fld 2 Fld 3
Key 1 A B C
Key 2 A B C
Key 3 A B C

Table2 Fld 1 Fld 2 Fld 3
Key 1 A X C
Key 2 A B Y
Key 3 A B Z

The output I am looking for is something like this:

Key1, Field2, B, X
...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Compare two tables field by field