Re: [SQL] A tricky sql-query...

2003-11-02 Thread Christopher Browne
Quoth [EMAIL PROTECTED] (Mark Stosberg): > On 2003-10-22, Timo <[EMAIL PROTECTED]> wrote: >> >> You can't have any recursion in an pure sql-query, can you? > > It depends on how you think of recursion, I'd say. You join on the same > table a number of times, by giving it a different alias each time

Re: [SQL] A tricky sql-query...

2003-11-02 Thread Rod Taylor
On Sun, 2003-11-02 at 19:42, Mark Stosberg wrote: > On 2003-10-22, Timo <[EMAIL PROTECTED]> wrote: > > > > You can't have any recursion in an pure sql-query, can you? > > It depends on how you think of recursion, I'd say. You join on the same > table a number of times, by giving it a different ali

Re: [SQL] A tricky sql-query...

2003-11-02 Thread Mark Stosberg
On 2003-10-22, Timo <[EMAIL PROTECTED]> wrote: > > You can't have any recursion in an pure sql-query, can you? It depends on how you think of recursion, I'd say. You join on the same table a number of times, by giving it a different alias each time. You have to manually specify (or generate with

[SQL] A tricky sql-query...

2003-10-23 Thread Timo
We have a small association and the association has a cabin. Members of the association can rent a term to stay in the cabin but as the cabin has turned out to be very famous we have had to establish an application policy for that. It goes like this: 1. There's a seniority queue for this purpose