记录一个update 连接查询语句

update ic_memb_audit C inner join ic_member A ON C.audit_membID =A.memb_id inner join ic_memberlevel B ON A.memb_level = B.level_rank
set audit_stock_limit=level_ic,audit_super =level_super

分享到QQ空间

Comments are closed.