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