I need to determine how to setup a Access query.
I have a item database with say 300 items. I also have an inventory file which is based on location information.
THe query below needs to display all the items from the item file using the inventory information selected for that location.
However when I run this query, I only get records which have information in the inventory file. Not all of them. I have even tried RIGHT JOIN. Access does not have OUTER JOIN.
SELECT Item.SKU, Item.Class, Item.Itemdescription AS Description,
Item.ItemSize AS [Size], Inventory.StartInventory AS [Start Inventory], Inventory.EndInventory AS [End Inventory] From Item, Inventory
LEFT JOIN Inventory ON (Item.SKU = Inventory.SKU' and inventory.Location = 'GS1')