Re: What looks like a basic SQL query still not resolved

Oracle has a CONNECT BY clause to do recursive joins like this - not a
help to you as such, but the point is that they have found it necessary
to have a specific feature to accomplish what you're trying to do. They
used to call the technique "tree walking". Don't know if SQL Server has
something similar ...

.

Relevant Pages

  • Re: How can I use N different where clauses in a single update statement?
    ... value is 'ABCDEF', and you update it to the same value, ... won't that still be an update that gets processed by Oracle? ... What I'm really looking for is how to vary the WHERE clause for each ... Prev by Date: ...
    (comp.databases.oracle.misc)
  • "order by" with "where value in" clause problem
    ... I'm using Oracle 8i on Solaris box. ... This list will be passed to query where in clause: ... Prev by Date: ...
    (comp.databases.oracle.misc)
  • FOR UPDATE WAIT
    ... Can anybody explain why Oracle allows only INTEGERs for seconds in ... the clause FOR UPDATE WAIT? ... What would be the reason for such behavior and implementation? ... Prev by Date: ...
    (comp.databases.oracle.server)
  • Re: Locking question when using Select clause with For Update and Skip locked
    ... table for update and skipped the rows locked by other sessions on same ... select top 1 empno from emp ... (we also have order by clause but will remove it here for simplicity) ... Now on Oracle system it is ...
    (comp.databases.oracle.server)
  • Re: Outer join by (+)
    ... Robert Klemme wrote: ... I can read the standard SQL just fine, because that's what I'm used to. ... WHERE clause excludes. ... This still leaves the issue of lesser expressiveness for the proprietary Oracle syntax. ...
    (comp.databases.oracle.server)