Here is the structure of my tables i am using.

CREATE TABLE Billing (

CUSTCODE VARCHAR,

SALESID ...

For some reason I had a lot of problems with the "where not exists" maybe I mistyped. But with the database we are using there are no primary keys or...

Thank you for your reply. I created a view at first, but the problem with that was it needed to accept parameters for a start date and ending date. So...