SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 MS Access
 Need some help...		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tkelley24
Starting Member

USA
4 Posts
Posted - 12/06/2012 :  23:40:51  Show Profile  Reply with Quote
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

India
4 Posts
Posted - 12/14/2012 :  06:41:25  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000