Posted by pbd22 on 11/08/06 14:38

yes, thank you.
i have done that and the results are as expected.
the left-hand side of the OR condition evaluates,
so, all values that are 0 and have the mag... email
address are returned. the right-hand side does
not evaluate. if i run the statement with the AND
condition, i get nothing back.

Alex Kuznetsov wrote:
> pbd22 wrote:
> > thanks for the suggestion,
> > but the results are still the same - all the rows update
> > to the new value, not just the single, intended row.
> >
> > other thoughts?
>
> Test your WHERE clause as follows:
>
> SELECT * FROM add
> WHERE (add.add_status = 0 and add.add_email = 'mag...@rice.edu' )
> or add_s in
> (
> SELECT a.add_s
> FROM add a, edit e
> WHERE a.email_address = e.email_address
> and e.public_name = 'professor'
> )
>
>
>
>
> -----------------------
> Alex Kuznetsov
> http://sqlserver-tips.blogspot.com/
> http://sqlserver-puzzles.blogspot.com/

• Next in forum: Re: Help with joining/selecting values to show
• Prev in forum: Re: Please Help With Complex Update Statement Logic
• Thread view: Re: Please Help With Complex Update Statement Logic

[Reply to this message]