Thread: 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
Deepali, > 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 afraid that your question is much to general to be answered. Frankly, I'm not sure what you mean by "nested SQL statement." Further, It sounds like you need some general knowledge. SInce this is an internship, ask them to buy you some books: ................Database Design for Mere Mortals any/all of:.....PostgreSQL Introduction & Concepts ................SQL for Smarties > 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. This is the wrong list for questions about ADO. Try pgsql-interfaces instead, or perhaps MSDN (msdn.microsoft.com). Good luck! -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
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