摘要： 寫出以下SQL語句update O10YSSK set YGGH=t4.em_code from O10YSSK t1 inner join (select distinct t1.em_no,max(t1.i_date) as RQ0 from code_no_tab t1 inner join O10YSSK t2 on t1.em_no=t2.YGKH and t2.RQ>=t1.i_d... 阅读全文