Hi Robert,

> How would the following query be rewritten using INNER JOIN syntax?
>
> SELECT MAX( Eca.maxSeverity), SUM( eca.elementCount )
> FROM Eca, Path, Link
> WHERE Path.ancestorId = 8
> AND Path.descendentId = Link.parentId
> AND Link.childId = Eca.oid

SELECT
MAX( Eca.maxSeverity ),
SUM( Eca.elementCount )
FROM Eca
JOIN Link ON Link.childId = Eca.oid
JOIN Path ON Path.descendentId = Link.parentId
WHERE Path.ancestorId = 8


Grtz,
Paul Vinkenoog