Newbie SQL question

Here is a query that will get me some data:

select a.accountnumber, b.date, a.date
from atable a, btable b, needthistojointable n where a.accountnumber = n.accountnumber
and n.anotheraccountnumber = b.anotheraccountnumber and a.date < b.date

It will spit out a couple of rows:

a.accountnumber a.date b.date 5000055222321 04/01/2003 04/04/2003
6213251362635 04/06/2003 04/07/2003

My problem is that a.date needs to be >= b.date, and my current solution is to manually go through and edit each tuple that has a problem. I would like to write an update script, but I can't seem to get it to work. It keeps giving me "single-row subquery returns more than one row."

I know that you may not be able to solve the problem because you don't know the structure, but some pointers will help.

Thanks,

Joe Received on Mon Apr 07 2003 - 14:13:01 CDT