Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A71A4475425 for ; Mon, 27 Jan 2003 01:59:42 -0500 (EST) Received: from lucidindia.net (unknown [61.11.73.194]) by postgresql.org (Postfix) with ESMTP id E798E47636F for ; Mon, 27 Jan 2003 01:59:37 -0500 (EST) Received: from a4005 ([192.168.1.18]) by lucidindia.net (8.11.6/8.11.6) with SMTP id h0R6xYE08957 for ; Mon, 27 Jan 2003 06:59:34 GMT Message-ID: <001601c2c5d1$a646cdd0$1201a8c0@a4005> From: "shreedhar" To: "Postgres" Subject: how sub queries and joins differs funcationally Date: Mon, 27 Jan 2003 12:29:34 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/278 X-Sequence-Number: 7120 Can any body tell that how sub queries and joins differs funcationally. Because sub queries taking lot of time than joins. Regards, Sreedhar "Faith, faith, faith in ourselves, faith, faith in God, this is the secret of greatness. If you have faith in all the three hundred and thirty millions of your mythological gods, and in all the gods which foreigners have now and again introduced into your midst, and still have no faith in yourselves, there is no salvation for you. " (III. 190)