Does DBMaker support the UPDATE/INSERT/DELETE with target table in subquery? (DBMR: 1913)
At present, DBMaker does not support the UPDATE/INSERT/DELETE with target table in subquery, but user can replace it by temporary table.
For example:
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): [DBMaker] cannot select into a table which has already been referenced in the query