Limiting Query to Columns that do not match

[GMC111568]

In my Access database, I have two tables, from different sources, that have similar data. Each table has a customer number, and a customer name.

I'm trying to create a query that will show only names that don't match for a given customer number.

So, in Table_1, I have

3704 Fred Flintstone
3705 Barney Rubble
3706 Wilma Flintstone

In Table_2, I have

3704 Fred Flintstone
3705 George Jetson
3706 Wilma Flintstone

I've made a query that joins on customer number, and shows the name fields from both, so it looks like this:

3704 Fred Flintstone Fred Flintstone
3705 Barney Rubble George Jetson
3706 Wilma Flintstone Wilma Flintstone

But, what I want, is for it to only show the row that doesn't match:

3705 Barney Rubble George Jetson

Any suggestions on how to accomplish this? I'm using Access 2010

 

[james_lankford]

didn't try it, but maybe something like this

select 
  Table_1.ID, 
  Table_1.customer_name,
  Table_2.customer_name,
from 
  Table_1 
    inner join 
      Table_2 
    on
    Table_1.ID = Table_2.ID
where 
(
  Table_1.ID in
  (
    select 
      Table_1.ID 
    from 
      Table_1 
        inner join 
          Table_2 
        on
        Table_1.ID = Table_2.ID
        and  
        Table_1.name <> Table_2.name
  )
)

 

[GMC111568]

That worked perfectly! Thank you!!

 

[xenou]

You might need to think about what records are in one but not the other, if this is a possibility.

Table1:
3707 Scooby Doo
3709 Velma

Table2:
3708 Fred
3710 Daphne