mysql 利用其它表字段更新本表

update pcm3_cnt_m  set stat = 'stp',end_dt=(select stop_dt from pcm3_cnt_stop where phid = '843190717000001') where phid = (select phid_cnt from pcm3_cnt_stop where phid = '843190717000001');