其语言结构为:
from table left join(inner join、right join、join等关联) ...on ....
事例代码:
update table1 set table1.name=table2.name from table1 left join table2 table1.id=table2.id
delete 写法与update差不多
以上是在SQLSER环境下实验的,ORACLE下尚未实验!
其语言结构为:
from table left join(inner join、right join、join等关联) ...on ....
事例代码:
update table1 set table1.name=table2.name from table1 left join table2 table1.id=table2.id
delete 写法与update差不多
以上是在SQLSER环境下实验的,ORACLE下尚未实验!