联表更新删除access/mssql

备忘

Access:
UPDATE TABLE1 INNER JOIN [TABLE2] ON (XXXX) SET [FIELD1]=XXXX
DELETE TABLE1.* from TABLE1 INNER JOIN [TABLE2] ON (XXXXX)

MSSQL:
UPDATE TABLE1 SET [FIELD1]=XXXX FROM TABLE1 INNER JOIN TABLE2 ON (XXXXX)
DELETE TABLE1 FROM TABLE1 INNER JOIN [TABLE2] ON (XXXXX)

发表评论

电子邮件地址不会被公开。 必填项已用*标注