A
andrewg
Hey, my sql skills are passable but this is over my head i think....
I have a nice sql query as follows:
SELECT Job.id AS Job_id, Job.Order_Id, Job.StartDate, Job.Referral,
Job.Subject, Order.Id AS Order_Id, Order.isOrder, Order.SellingPrice,
Client.CompanyName, Client.email
FROM Client INNER JOIN ([Order] INNER JOIN Job ON Order.Id =
Job.Order_Id) ON Client.CustomerID = Order.CustId
WHERE (((Job.StartDate) Between #10/6/2006# And #11/6/2006#));
Now how would I EXCLUDE rows from this query based on rows which exist
in another table. For example, if a row exists in table
tblReminderSent I don't want that associated OrderID to show up in the
above query....
where do I go from here?
I have a nice sql query as follows:
SELECT Job.id AS Job_id, Job.Order_Id, Job.StartDate, Job.Referral,
Job.Subject, Order.Id AS Order_Id, Order.isOrder, Order.SellingPrice,
Client.CompanyName, Client.email
FROM Client INNER JOIN ([Order] INNER JOIN Job ON Order.Id =
Job.Order_Id) ON Client.CustomerID = Order.CustId
WHERE (((Job.StartDate) Between #10/6/2006# And #11/6/2006#));
Now how would I EXCLUDE rows from this query based on rows which exist
in another table. For example, if a row exists in table
tblReminderSent I don't want that associated OrderID to show up in the
above query....
where do I go from here?