Operations between two tables in a T-SQL database

--Modify the data in the table according to another table

Update ADMIN_FCOUTDT set Olastid=t.contractid from (select Crm_contract.contracttopic,crm_contract.contractid from Admin_fcoutdtleft join Crm_contract on admin_fcoutdt.contractname=crm_contract.contracttopic) Twhere Admin_ fcoutdt.contractname=t.contracttopic--query Another table insert into ADMIN_FCOUTDT (protype,number) Select ' Test ', num from crm_ Contract--deletes data from a table based on another table delete from Admin_fcoutdt where LastID in (select ID from admin_fcout where prod like '%ef% ')--two table fit and query (a query between two tables lists only this one.) A separate chapter will be introduced) Select Fnumber, fname from Admin_fcoutdt where State=1union allselect nub as Fnumber,fname  

Operations between two tables in a T-SQL database