Re: Please Help With Complex Update Statement Logic
Posted by markc600 on 11/08/06 13:32
Try adding some brackets
UPDATE add
SET add_s = 1
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'
)