I am trying to update a related table with a subquery. This is what I am
using -

update tbl1 set col1=col1+1 where ID IN (select ID from tbl2 where
status='Active');

But I get syntax error. I am not much of a database guy, so can't understand
what am I doing incorrectly. Can someone help?

TIA,
- Manish


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to