| Subject | Written using INNER JOIN syntax, how? |
|---|---|
| Author | Robert DiFalco |
| Post date | 2003-07-30T23:19:48Z |
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, Path, Link
WHERE Path.ancestorId = 8
AND Path.descendentId = Link.parentId
AND Link.childId = Eca.oid