DBMaster是否支持在子查询中对目标表进行UPDATE/INSERT/DELETE?(DBMR: 1913)
目前,DBMaster不支持在子查询中对目标表进行UPDATE/INSERT/DELETE操作,不过用户可以通过临时表来替换目标表。
例如:
dmSQL> INSERT INTO uselgcsvcs
SELECT host_id, service_name, MAX(specification) as specification FROM usesvcs T WHERE NOT EXISTS (SELECT service_name FROM uselgcsvcs L WHERE T.host_id = L.host_id and T.service_name = L.service_name) GROUP BY host_id, service_name;
ERROR (6172): [DBMaster] cannot select into a table which has already been referenced in the query