|
|
Posted by Alex Kuznetsov on 11/08/06 14:25
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/
Navigation:
[Reply to this message]
|