X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id CDA023101E8 for ; Fri, 27 Jun 2003 14:18:58 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 82577-03 for ; Fri, 27 Jun 2003 11:18:48 -0300 (ADT) Received: from vadangyal.vnet.hu (mail.vnet.hu [213.163.59.4]) by svr1.postgresql.org (Postfix) with ESMTP id 344B7310131 for ; Fri, 27 Jun 2003 11:18:48 -0300 (ADT) Received: from compaq (adsl213069.vnet.hu [62.77.213.69]) by mail.vnet.hu (iPlanet Messaging Server 5.1 Patch 1 (built Jun 6 2002)) with ESMTPA id <0HH500EVO93CYP@mail.vnet.hu> for pgsql-sql@postgresql.org; Fri, 27 Jun 2003 16:18:48 +0200 (CEST) Date: Fri, 27 Jun 2003 16:18:10 +0200 From: =?iso-8859-1?Q?Egy=FCd_Csaba?= Subject: Re: Getting all rows even if not a member of any groups To: Bruno Wolff III Cc: pgsql-sql@postgresql.org Reply-To: =?iso-8859-1?Q?Egy=FCd_Csaba?= Message-id: <00e501c33cb6$f4cc4cd0$230a0a0a@compaq> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2727.1300 X-Mailer: Microsoft Outlook Express 6.00.2720.3000 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT X-Priority: 3 X-MSMail-priority: Normal References: <11362.1056313692@www59.gmx.net> <00bd01c33c9d$1b584e90$230a0a0a@compaq> <20030627140854.GA15269@wolff.to> X-Archive-Number: 200306/314 X-Sequence-Number: 14072 Bruno, > Please don't reply to messages to start a new thread. sorry, I will never do such things in the future. > select t_productgroups.name as pgroup, > t_products.id as productid > from t_products > left join (t_prod_in_pgr > join t_productgroups on (t_productgroups.id = t_prod_in_pgr.productgroupid)) > on (t_products.id=productid) > order by pgroup, productid; This is absolutelly what I want, but I can't understand how it is working. Where can I find a descriptive (tale-like, for kids ... :) ) documentation about using joins? Thank you wery mauch. -- Csaba --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 2003. 06. 18.