K
KIMA06
All,
Here is what I am dealing with. I have two tables: West(NY) and South (NY).
These tables are supposed to be identical, however the person that updates
South(NY) messed up big time and has added more information than what should
be in the table.
Both tables are built the same and have the same column headings (for the
sake of this query, I will call them Field1, Field2, Field3, and Field 4. I
need to use West(NY) table as the master table, and I need to run a query
that will show me what is in the South(NY) table that is different. For
instance lets just say that in South(NY) Table that Field2 has "Farmingdale
(916)". However in the West(NY) table, Field2 is just "Farmingdale".
The unmatched query is not working, so if you have an SQL statement that I
can play with, it will be greatly appreciated. Thanks in advance.
Here is what I am dealing with. I have two tables: West(NY) and South (NY).
These tables are supposed to be identical, however the person that updates
South(NY) messed up big time and has added more information than what should
be in the table.
Both tables are built the same and have the same column headings (for the
sake of this query, I will call them Field1, Field2, Field3, and Field 4. I
need to use West(NY) table as the master table, and I need to run a query
that will show me what is in the South(NY) table that is different. For
instance lets just say that in South(NY) Table that Field2 has "Farmingdale
(916)". However in the West(NY) table, Field2 is just "Farmingdale".
The unmatched query is not working, so if you have an SQL statement that I
can play with, it will be greatly appreciated. Thanks in advance.