联接的删除方法和更新方法

      联接的删除方法，通过条件删除      DELETE from  a       FROM [NewSportsStore].[dbo].[Products] as a       LEFT JOIN NewSportsStore.dbo.Orders as b       on a.ProductID=b.OrderId       WHERE b.OrderId IS null      联接的更新方法，通过条件更新      UPDATE  a set Name+='Young'      FROM [NewSportsStore].[dbo].[Products] as a      LEFT JOIN NewSportsStore.dbo.Orders as b       on a.ProductID=b.OrderId       联接可以转化为标准的delete，update语句，where exists（ ｓｑｌ语句）