query to return all store items

[xmohamedx]

I am trying to create a query in a store database between 2 tables (one to many relationship) the first table contains items and the initial quantities, the second the purchased item by date
when i try to make a query between the 2 tables by totals , the query just return the items that have been already purchased , but i want to return all the items in the store even i have no purchasing order...
the file have the example

Your time and help will be greatly appreciated

thanks a lot

[JoeM]

You need to use a Left Join in order that records from your first table without matching records in your second table are not dropped.
See: http://www.techonthenet.com/access/queries/joins2.php

[xmohamedx]

You need to use a Left Join in order that records from your first table without matching records in your second table are not dropped.
See: http://www.techonthenet.com/access/queries/joins2.php

Many thanks JoeM, that works perfectly

[xmohamedx]

that works perfectly, many thanks JoeM

[JoeM]

You're welcome.