[Solved]Multiple Databases in WHERE clause

[Canton]

 

UPDATE ep3_db_auth.bg_user SET cash = cash + (SELECT a_count FROM ep3_db.t_stash00 WHERE a_item_idx = 9891 AND user_code = a_user_idx) WHERE user_code IN (SELECT a_user_idx FROM ep3_db.t_stash00 WHERE a_item_idx = 9891);

 

 

Have fun