When you want to update multiple columns at once, you list all of the columns to be updated ... UPDATE CONTACT C SET (C.PHONE, C.FAX) = ( SELECT P.PHONE, ...
確定！ 回上一頁
