Re: Joining three data sources.

On Thu, 20 Jun 2002 08:27:07 +0200
Janning Vygen <vygen(at)gmx(dot)de> wrote:

> Oh thanks a lot. You pushed me in the right direction. i still get headache
> when trying to write complicated selects. there was something wrong
> in your statement

Oh! I slipped up. You are exactly right.

> but i was able to correct it by myself. Thanks for your help!!
> Are you able to type those queries in minutes?? It seems so ... amazing!

No. Actually, I may have spent a few hours before I was aware of
making use of Max/Min aggregations to divide the values of the
team_id into the team1_id or tema2_id.

>
> > As for Goal table, if it has a large number of the rows, you maybe
> > need to create a unique index on it.
>
> of course. it was just an example...
>
> kind regards
> janning

Regards,
Masaru Sugawara