Query Showing No Activity

[tabbycat1234]

I have a customer table and a purchase table. I have gotten the query set up so that it shows me all the purchases that a customer has made during a certain time frame. I want to run another query that will show me all the customers that have not purchased anything in a time from. How do you program the criteria so that it will return the customers that have not bought anything.

The SQL statement is

SELECT tblcustomers.CompanyName, tblpurchasehistory.ItemBought
From tblcustomers INNER JOIN tblpurchasehistory ON tblcustomers.CustomerID = tblpurchasehistory.CustomerID;



Thanks

[orange]

see this for a sample
http://www.techonthenet.com/access/queries/joins2.php

[tabbycat1234]

I have the joins correctly but it is returning all the records

[orange]

If everything is correct, then there wouldn't be a problem.

Please post the sql for your query.

[tabbycat1234]

SELECT tblpurchasehistory.CustomerID, Qrycustomerfornoactivity.CustomerID, Qrycustomerfornoactivity.CompanyName, tbluitempurchase.Item
FROM (Qrycustomerfornoactivity INNER JOIN tblpurchasehistory ON Qrycustomerfornoactivity.CustomerID = tblpurchasehistory.CustomerID) INNER JOIN tbluitempurchase ON tblpurchasehistory.ItemBought = tbluitempurchase.Itempurchaseid;

(This is showing the item that I have in purchased. I need it to show the customer that has not purchased anything)

[orange]

In your first post you had 2 tables. In this last post you have added a query.

Please show the sql for the first query. If you look at the link I sent you will see it had a left join.

[tabbycat1234]

SELECT tblpurchasehistory.CustomerID, tbluitempurchase.Item
FROM tblpurchasehistory INNER JOIN tbluitempurchase ON tblpurchasehistory.ItemBought = tbluitempurchase.Itempurchaseid;

[tabbycat1234]

These two tables do not show names of the customer that is why I added the query. I need to have the name of the customer in there also

[orange]

Based on your first query, your sql will look something like

SELECT tblcustomers.CompanyName
, tblpurchasehistory.ItemBought
From tblcustomers LEFT JOIN tblpurchasehistory 
ON tblcustomers.CustomerID = tblpurchasehistory.CustomerID
WHERE tblpurchasehistory.CustomerID Is Null;

There are great examples on various sql queries here
http://www.w3schools.com/sql/sql_join_left.asp

[tabbycat1234]

Thank You that did the job. I really do appreciate the help!