Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f6ALEta15595
	for <pgsql-sql@postgresql.org>; Tue, 10 Jul 2001 17:14:55 -0400 (EDT)
	(envelope-from pgsql-sql-owner@postgresql.org)
Received: from mail.ppc.com ([12.38.16.34])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f66Hrta94944
	for <pgsql-sql@postgresql.org>; Fri, 6 Jul 2001 13:53:56 -0400 (EDT)
	(envelope-from DAgarwal@PPC.com)
Received: by ppc-mail with Internet Mail Service (5.5.2653.19)
	id <N6ZTFV4T>; Fri, 6 Jul 2001 13:52:58 -0400
Message-ID: <6CD95B940E5ED4119CCE00D0B78ED7C8DC3C09@ppc-mail>
From: Deepali Agarwal <DAgarwal@PPC.com>
To: "'pgsql-sql@postgresql.org'" <pgsql-sql@postgresql.org>
Subject: SQL question
Date: Fri, 6 Jul 2001 13:52:57 -0400 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Archive-Number: 200107/121
X-Sequence-Number: 3916


 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