Comparing table attributes in ArcGIS 10(ArcInfo)

Question

I'd like to compare attributes of two point layers . the layers have some similar records and i try to find these . ArcGIS 10.1 has a tool to comparing attributes but i could'nt find any similar tools in ArcGIS 10 . How can i compare two attribute and find similar records?

Answer 1

EDIT:
I use this when I have already done a join of my data.
Selecting other fields that are similar (or not).
(Sorry I was out of office and assumed as I use it a key field between the two tables)

In the select by attribute tool.
(Found under the selection pull down)
Type.
Mytable1.feild1 = mytable2.field2
Another method (alternative to Aaron's [which his will work great for you])
Is to do a join on the fields that have the same values and select the "Keep only matching records" option.

Answer 2

Try using Feature Compare (Data Management):

Compares two feature classes or layers and returns the comparison results. Feature Compare can report differences with geometry, tabular values, spatial reference, and field definitions.

Alternatively, use Table Compare (Data Management):

Compares two tables or table views and returns the comparison results. This tool can report differences and similarities with tabular values and field definitions.

Answer 3

There are multiple GP tools available in ArcGIS 10, such as 'Find Identical' and 'Delete Identical'. Please refer to these Esri KB articles to find out more:

• HowTo: Identify duplicate field values
• HowTo: Find duplicate or coincident features
• FAQ: Does ArcGIS provide a way to identify or remove features with duplicate geometries?

Just in case you want to get access to more advanced tools on GIS data management within your business workflows regarding to finding similar features both geometry and attribute wise, consider taking a look at the ArcGIS Data Reviewer 10 (the link on managing duplicate geometries).