下面將通過兩種方式來實現： 將 表A 與 表B 不重復的User信息 插入表B ## 方法1：Merge Into ~~~ MERGE INTO Table A USING Table B ON (A.user_id = B.user_id) WHEN NOT MATCHED THEN INSERT VALUES (B.user_id, B.user_name, B.user_sex); ~~~ ## 方法2： Not Exists ~~~ INSERT INTO Table (Id,Name,Sex) SELECT id,name,sex FROM Table A WHERE User_Id = ' Uid ' AND NOT EXISTS ( SELECT * FROM Table B WHERE A.MI_NO=B.MI_NO ) ~~~