根據另一張表修改表中的資料updateAdmin_FCOutDtsetoLastId=T.contractIDfrom(selectcrm_contract.contractTopic,crm_contract.contractIDfromAdmin_FCOutDtleftjoincrm_contractonAdmin_FCOutDt.ContractName=crm_contract.contractTopic)TwhereAdmin_FCOutDt.ContractName=T.contractTopic--把查詢另一張表insertintoAdmin_FCOutDt(protype,number)select"測試",numfromcrm_contract--根據另一張表刪除表中的資料deletefromAdmin_FCOutDtwhereLastIdin(selectidfromAdmin_FCOutwhereprodlike"%EF%")--兩表合併查詢（兩個表之間的查詢只列出這一個。會有單獨的章節介紹）selectfnumber,fnamefromAdmin_FCOutDtwherestate=1unionallselectnubasfnumber,fnamefromcrm_comtract