Re: Newbie SQL question

"Joe Chancellor" <Joe at NoSP4M eat-me dot net> wrote:

>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-
>
>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
>

If
a.date needs to be >= b.date why are you specifying a.date < b.date ?

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Mon Apr 07 2003 - 15:46:13 CDT