sqlServer执行的格式
update a set a.first = b.pid from tableA a,tableB b where b.catid = a.second
oracle执行的格式
update tableA a set level3 = (select pid from tableB b f where b.catid =a.catid)
sqlServer执行的格式
update a set a.first = b.pid from tableA a,tableB b where b.catid = a.second
oracle执行的格式
update tableA a set level3 = (select pid from tableB b f where b.catid =a.catid)