SQL Query

We need a SQL statement for an ASP Application using MS SQL 2000 We have two tables one Clients and the other Payments. We need our application to list all clients that do NOT have a payment record between a certian date range. The Client table fields are clienid, firstname, lastname and the payments table has clientid, date2. We tried SELECT [login to view URL], [login to view URL], [login to view URL], [login to view URL] FROM Clients INNER JOIN Payments ON [login to view URL] = [login to view URL] where not [login to view URL] > 1/29/2002 and < 2/29/2002 but this does NOT work. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. ## Platform ASP ## Deadline information NEED IS ASAP