Combining tables in a query

[pltnsgt]

I am rather new to access and only have a public education, so be gentle. My problem is I have made two tables within access. The first one is names and other information (5800 accounts). The second one is names and phone numbers (2300 accounts). The names are in the system exactly the same for both tables. All the names on the second list are contained within the first list. I need to create a table or query that will match the names with the phone numbers and also show me the names that I do not have the phone numbers for. Basically I need a list that has 5800 accounts, shows who has a phone number and who does not have a phone number. I have made a relationship between the two tables based on the person’s name. I used the code below and put the code in the “criteria” and “name” block. However, I received no results. When I remove the code from the query I receive only the results from list 2 (2300 accounts) and no data from list 1. Any Ideas?

FROM [5480 Master Data] INNER JOIN [5480 Meal Collection] ON [5480 Master Data].name=[5480 Meal Collection].name

 

[Sanjeet Prasad]

Try this SELECT 5480 Meal Collection.name, 5480 Meal Collection.phonenumber
FROM [5480 Master Data] INNER JOIN 5480 Meal Collection ON 5480 Master Data.names = 5480 Meal Collection.names;

 

[Adeptus]

Something like this:

SELECT [5480 Master Data].name, [5480 Meal Collection].phonenumber
FROM [5480 Master Data] [B]LEFT OUTER [/B]JOIN [5480 Meal Collection] ON [5480 Master Data].name = [5480 Meal Collection].name;

An inner join will only give you records where both sides have a result (so, only the 2300 with phone numbers). An outer join will give you everything from one table, plus matches from the other.

 

[pltnsgt]

Sounds like a outer join is what I need to do. Any examples? Thanks for the help!