UnMatched Data Query (Edit Data)

[pedraza4]

Hi!!!
I have two tables in my database, one of the table is the main which contain the primary key, The other table was exported from an external system and should contain the primary key in one of the fileds in the table. The problem with the other table is that the name can differ from the primary key . a point or letter (e.g primary key is TIC-1120, but in the other table appears as TIC.1120.

I created an unmatched query in order to find these records and modify it in order to be similar to the primary key. The problem that I have is that when I tired to modify the record in the unmatched query, I cannot modify it.

I will appreciate any help



thanks!!!!!

[evander]

Did you try to use nested queries or subqueries?

[pedraza4]

I have not tried that options. How can I do it??

[evander]

SELECT * FROM Table1
WHERE SomeID NOT IN (SELECT * FROM Table 2)

You can actually re-state this into an outer join query. But I prefer nested queries sometimes. It's more readable.