Re: Joining three data sources.

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