Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 15A9A9FA4F7 for ; Tue, 6 Mar 2007 03:41:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 26873-01-4 for ; Tue, 6 Mar 2007 03:41:15 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 51EC19FB42E for ; Tue, 6 Mar 2007 03:41:15 -0400 (AST) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 13CAD7623B; Tue, 6 Mar 2007 07:37:40 +0000 (GMT) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id E663F27408E; Tue, 6 Mar 2007 07:37:39 +0000 (GMT) Message-ID: <45ED1A43.5080708@archonet.com> Date: Tue, 06 Mar 2007 07:37:39 +0000 From: Richard Huxton User-Agent: IceDove 1.5.0.9 (X11/20061220) MIME-Version: 1.0 To: hytech.qa@gmail.com Cc: pgsql-performance@postgresql.org Subject: Re: Hibernate left join References: <1172817991.353170.276310@t69g2000cwt.googlegroups.com> In-Reply-To: <1172817991.353170.276310@t69g2000cwt.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.207 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200703/121 X-Sequence-Number: 23526 hytech.qa@gmail.com wrote: > Hi , > I want to know about hibernate left join, > Is their any way to do left join in hibernate ?. > > > Please give me an example of hibernate left join with its maaping This isn't really a performance question, or even a PostgreSQL question. You'll do better asking this on the pgsql-general list and even better asking on a hibernate-related list. Another tip - for these sorts of questions many projects have details in their documentation. Google can help you here - try searching for "hibernate manual left join" and see if the results help. HTH -- Richard Huxton Archonet Ltd