Received: from mail.utexas.edu (wb3-a.mail.utexas.edu [128.83.126.138]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6B2ooa66075 for ; Tue, 10 Jul 2001 22:50:50 -0400 (EDT) (envelope-from webmaster@robbyslaughter.com) Received: (qmail 21620 invoked by uid 0); 11 Jul 2001 02:50:45 -0000 Received: from adsl-208-190-152-103.dsl.austtx.swbell.net (HELO robmanbox) (208.190.152.103) by umbs-smtp-3 with SMTP; 11 Jul 2001 02:50:45 -0000 Reply-To: From: "Robby Slaughter" To: "Deepali Agarwal" , Subject: RE: SQL question Date: Tue, 10 Jul 2001 21:51:39 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <6CD95B940E5ED4119CCE00D0B78ED7C8DC3C09@ppc-mail> X-Mimeole: Produced By Microsoft MimeOLE V5.50.4133.2400 Importance: Normal X-Archive-Number: 200107/135 X-Sequence-Number: 3927 Deepali, Bruce Momjian's book on SQL provides a great intro to SQL, including joins. http://www.ca.postgresql.org/docs/aw_pgsql_book/ If you have a specific question, please post that to a list Good luck! -Robby -----Original Message----- From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Deepali Agarwal Sent: Friday, July 06, 2001 12:53 PM To: 'pgsql-sql@postgresql.org' Subject: [SQL] SQL question hello, I have a simple question about nested SQL statements. I remember having learnt of another way of writing nested SQL statements, using Joins I guess. I'm buildingh an ASP/ADO application or which using nested select becomes too complicated. Could you please throw some light ( preferably with an example) on how i can use a join or any other method instead of suing nested SQL statements. Also, would you be able to tell me how to use a nested DQL quesry/join query with an ADO command object, i.e the commandtext property? Thank you for your help. -Deepali Deepali Agarwal Intern Project Performance Corporation 7600, Colshire Drive McLean, VA 22101 (703)748-7089 www.ppc.com ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl