Hi,

I posted a questions a week ago and got no answer. Is the solution so
obvious for everybody? Or is it not clear, what I mean?

Here I post it again:


I have a database with the following tables:

NATIONS
- REGIONS
-- CLUBS
--- PERSONS
---- RESULTS

I want to select results/persons by nations, regions or clubs.

Because the data of the first three tables are very similar and I'm
not sure, if there may be a further level at some time, I would
prefere to make a recursive definition: Every club may have a parent
club and on the top level (nations) the parent will be null.

Since SQL does not support recursive calls, I'll have to join the
table CLUBS three times to get all levels.

Is a recursive design acceptable? Or will I run into problems at some
time. Nations will be up to 200 records, clubs maybe about
50'000-100'000 records, persons can be up to a million and results
will be several millions.

cu Christian