ms access - Compare 2 tables and show 1 column answer -

ms access - Compare 2 tables and show 1 column answer -

i have been trying phone number comparing 2 different tables. illustration

area 1: customer_ tel: 10123 10020 area 2: customer_tel: 02103 02351 10123

using area 1 reference, wanted outcome show numbers in area 2 not found ( or match) table 1.

i tried using this:

select area1.[customer_tel],area2.[customer_tel] area1 left bring together area 2 on area1.[customer_id]=area2.[customer_tel]

the query above identified numbers found in area 1 , went on show in show in area 2, client id column. next add together in using area1. [customer_tel]<>area2.[customer_tel] showed blank cells except headers.

hope kind soul help in tweaking it.

there several ways joins. next left join

select area2.[customer_tel] area2 left bring together area1 on area1.[customer_tel]=area2.[customer_tel] area1.[customer_tel] null

while here right join

select area2.[customer_tel] area1 right bring together area2 on area2.[customer_tel] = area1.[customer_tel] area1.[customer_tel] null

both result in same number of records while 'starting' different table.

ms-access