Show all stores on Query

[Guest]

I have a query set up that links between two tables by the store number. The
Store Table has all the store information of all 1,200 stores we call on.
The Master Table shows stores that we have sold items to for that specific
vendor. Some of the 1,200 stores from the Store Table will not have any
items sold to that store so will not have any information on the Master
Table. I want to have a query that shows every store regardless if we sold
any items to them or not so if they did not buy anything it would show the
store with a zero amount in the Inv Qty field. The query I have now only
shows the stores that have sales information in the Master table.

 

[Tom Ellison]

Dear Supe:

It sounds like you would want a LEFT JOIN:

SELECT *
FROM [Store Table] S
LEFT JOIN [Master Table] M
ON M.[Store Number] = S.[Store Number]

You need to first correct my spellings for tables and columns.

Tom Ellison

 

[Guest]

You need to change the connection between the two tables from inner join to
Left Or Right Joinn, that include all the records from the Store table, and
all the matching records from the second table

Check this link for explenation about the two links

http://www.databasedev.co.uk/query_joins.html