hi All, Will Ignite support Embed SUM DML Like this SQL updates:
UPDATE A a
SET a.total=(
SELECT SUM(b.cnt)
FROM B b
WHERE b.id = a.id
)
Always throw a fail to parse SQL query exception .
[email protected]
hi All, Will Ignite support Embed SUM DML Like this SQL updates:
UPDATE A a
SET a.total=(
SELECT SUM(b.cnt)
FROM B b
WHERE b.id = a.id
)
Always throw a fail to parse SQL query exception .
[email protected]