Subject Re: [firebird-support] Re: Self-referencing table SQL question
Author Ann W. Harrison
diwic2 wrote:
> Thanks to you all, for your answers. I take it as if there is no
> straight-forward SQL to do it, as you have to mess around with stored
> procedures to make it work.
> Interesting, though, that Oracle has support for such questions.

Oracle has one syntax, the SQL standard uses another. Many
people think the Oracle syntax is cleaner and easier to remember
than the standard syntax. Firebird has inherent support for
recursion - it was a normal part of GDML - but hasn't yet chosen
the syntax to use for SQL.