Is there a problem with this sql statement in MySQL? Why do you always report mistakes

  mysql, question

UPDATE zqbp_contract SET zqbp_contract.yingshou_money = zqbp_con_m.yingshou_money WHERE zqbp_contract.contract_id = zqbp_con_m.con_id

Error reporting:

[Err] 1054 – Unknown column ‘zqbp_con_m.con_id’ in ‘where clause’

Table structure:

Zqbp_con_m table has con_id field, screenshots cannot be sent.

UPDATE zqbp_contract,zqbp_con_m SET zqbp_contract.yingshou_money = zqbp_con_m.yingshou_money WHERE zqbp_contract.contract_id = zqbp_con_m.con_id