Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 0DB3D4767B4 for ; Thu, 20 Jun 2002 09:59:44 -0400 (EDT) Received: from mps2.plala.or.jp (mpsb-nat02.plala.or.jp [202.212.114.145]) by postgresql.org (Postfix) with ESMTP id CCD69476570 for ; Thu, 20 Jun 2002 09:55:09 -0400 (EDT) Received: from vip1600 ([218.47.116.198]) by mps2.plala.or.jp with ESMTP id <20020620135511.FEZP25092.mps2.plala.or.jp@vip1600>; Thu, 20 Jun 2002 22:55:11 +0900 Date: Thu, 20 Jun 2002 22:55:43 +0900 From: Masaru Sugawara To: Janning Vygen Subject: Re: Joining three data sources. Cc: pgsql-sql@postgresql.org In-Reply-To: <200206200627.g5K6R8X31442@janning.planwerk6.local> References: <20020619230842.91E2.RK73@sea.plala.or.jp> <200206200627.g5K6R8X31442@janning.planwerk6.local> Errors-To: rk73@sea.plala.or.jp Message-Id: <20020620225440.A150.RK73@sea.plala.or.jp> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Becky! ver. 2.00.11 X-Archive-Number: 200206/274 X-Sequence-Number: 8239 On Thu, 20 Jun 2002 08:27:07 +0200 Janning Vygen 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