Re: Recursive join - blind alley?

On Fri, 2 Jan 2004 08:53:47 -0000, "Mike MacSween" <mike.macsween.nospam_at_btinternet.com> wrote:

>This will be an orchestral management system. Musicians and other staff
>being booked/paid for jobs.
>
>A job may contain other jobs, e.g:
>
>World Tour contains
>US leg and Europe leg (and others)
>US leg contains State tours (and others)
>New Jersey tour contains Hoboken concert (and others)
>Hoboken concert contains dress rehearsal, 1st show, 2nd show

I'd just observe that a world tour is probably a tour, not a job. Whatever a job is. A tour isn't a leg. A leg isn't a job.

>Or a job may be single:
>
>My band plays at Simon Foreman's barmitzvah
>
>To account for the variability I imagined a recursive join.

What else did you imagine?

-- 
Mike Sherrill
Information Management Systems