match data?

[Winglet]

Hi, I'm pretty new to SQL queries.

Anyways, I have 2 tables.

Table A and B.

They both carry some of the same data except that the ID#'s will be different.

I want to create a list of all the data that matches say the criteria of name and address from these 2 tables and to print out the unique ID's along with this data for them.

Does this make sense?

[MMcCarthy]

Hi, I'm pretty new to SQL queries.

Anyways, I have 2 tables.

Table A and B.

They both carry some of the same data except that the ID#'s will be different.

I want to create a list of all the data that matches say the criteria of name and address from these 2 tables and to print out the unique ID's along with this data for them.

Does this make sense?

Look at the Find Duplicates wizard

[Winglet]

Look at the Find Duplicates wizard

hm, I see that. But the data I have is in 2 different tables? I simply want to match which records from these 2 tables have the same name or address