On Thu, 20 Jun 2002 08:27:07 +0200
Janning Vygen <vygen@gmx.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
