Delete Update 中使用JOIN （SQL,ACCESS整理）

delete的写法
Access中写为：
delete from t1 inner join t2 on t1.id = t2.tid

而SQL Server中须写为：
delete from t1 from t1 inner join t2 on t1.id = t2.tid


Update的写法
Access中：
update t1 inner join t2 on t1.id = t2.tid set t1.name='Liu'

SQL Server中：
update t1 set t1.name='Liu' from t1 inner join t2 on t1.id = t2.tid