以前一直以为 update语句中不能使用联接,后来在处理数据时发现是可以的。
- --更新认证
- UPDATE Contact
- SET
- [SalesAccreditation] = Accreditation_Upload_Contact.[Sales Accreditation]
- ,[SeAccreditation] = Accreditation_Upload_Contact.[SE Accreditation]
- from Contact,Accreditation_Upload_Contact where Contact.Email=Accreditation_Upload_Contact.Email