SQL question - Mailing list pgsql-sql

From Deepali Agarwal
Subject SQL question
Date
Msg-id 6CD95B940E5ED4119CCE00D0B78ED7C8DC3C09@ppc-mail
Whole thread Raw
Responses Re: SQL question  ("Josh Berkus" <josh@agliodbs.com>)
RE: SQL question  ("Robby Slaughter" <webmaster@robbyslaughter.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: joe.celko@trilogy.com (--CELKO--)
Date:
Subject: Re: need oracle ROWNUM equivalent
Next
From: Constantin Teodorescu
Date:
Subject: Re: [INTERFACES] Re: indexing arrays in pgaccess's query interface is failing