Need some help... - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Need some help...

Author

Topic

tkelley24
Starting Member

4 Posts

Posted - 2012-12-06 : 23:40:51

Need to list in access 2010 a list if inventory item numbers and there names if they have not been orderd by anyone. Working withthe following three tables..
any help would do.. thank you

inventory
Item_number
Item_name
Item_price

invoice
inv_number
cust_id
inv-date
inv-status

orders
inv_number
item_number

koolkaus
Starting Member

9 Posts

Posted - 2012-12-14 : 06:41:25

Create a Query and use the following SQL:

SELECT Inventory.Item_Number, Inventory.Item_name
FROM Inventory LEFT OUTER JOIN orders ON Inventory.Item_Number = orders.item_number WHERE orders.item_number IS NULL

This should help.
Cheers!
Kool

Rgds,
Kaus

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources