UPDATEtb_repair_basicSETtb_repair_basic.visitStatus='5'WHEREtb_repair_basic.idIN(SELECTmobileinfor.rbIdFROMtb_repair_mobileinformobileinforWHERE(mobileinfor.careerISNULLORmobileinfor.career=''))andtb_repair_basic.customerName!=''andtb_repair_basic.visitStatus='2'不能对同一个表tb_repair_basic同时select和update
