• ▼MSDN Library Visual Studio 6.0
    • ▶Welcome to the MSDN Library
    • ▶Visual Studio Documentation
    • ▶Visual Basic Documentation
    • ▶Visual C++ Documentation
    • ▶Visual FoxPro Documentation
    • ▶Visual InterDev Documentation
    • ▶Visual J++ Documentation
    • ▶Visual SourceSafe Documentation
    • ▶Tools and Technologies
    • ▶Microsoft Office Development
    • ▼Platform SDK
      • ▶What's New?
      • ▶Windows Programming Guidelines
      • ▼Database and Messaging Services
        • ▶DAO SDK
        • ▶Microsoft Data Access SDK
        • ▶Microsoft Exchange Server
        • ▶Messaging API (MAPI)
        • ▶Collaboration Data Objects
        • ▶Extending the Microsoft Exchange Client
        • ▼Microsoft SQL Server Programmer's Toolkit
          • ▶What's New in SQL Server 6.5
          • ▶SQL Server Setup
          • ▶Administrator's Companion
          • ▼Database Developer's Companion
            • ▶Before You Begin
            • ▶Overview
            • ▶Chapter 2 Working with Tables
            • ▶Chapter 3 Working with Data
            • ▼Chapter 4 Retrieving Data with Queries
              • ▶Creating Basic Queries
              • ▶Using Joins to Create Multitable Queries
              • Using Summary Queries
              • ▼Using Subqueries
                • Subquery Syntax
                • Subquery Rules
                • Subquery Examples
                • Subqueries Introduced with IN
                • Subqueries Introduced with NOT IN
                • Qualifying Column Names
                • Multiple Levels of Nesting
                • Subqueries in UPDATE, DELETE, and INSERT Statements
                • Subqueries with Aliases
                • ▼Comparison Operator Subqueries
                  • Comparison Operators Modified by ANY, SOME, or ALL
                • ▶Correlated Subqueries
                • ▶Subqueries Introduced with EXISTS
                • Subqueries Introduced with NOT EXISTS
                • Using EXISTS and NOT EXISTS to Find Intersection and Difference
                • Subqueries Used in Place of an Expression
              • ▶Displaying Totals with GROUP BY or COMPUTE
              • ▶Using Built-in Functions
            • ▶Chapter 5 Optimizing Performance
            • ▶Chapter 6 Using Stored Procedures and Triggers
          • ▶Transact-SQL Reference
          • ▶Programming SQL Distributed Management Objects
          • ▶Guide to Microsoft Distributed Transaction Coordinator
          • ▶Programming ODBC for SQL Server
          • ▶Programming DB-Library for C
          • ▶Programming DB-Library for Visual Basic
          • ▶Programming Open Data Services
          • ▶Glossary 6.0
      • ▶Graphics and Multimedia Services
      • ▶Internet/Intranet/Extranet Services
      • ▶Networking and Distributed Services
      • ▶COM and ActiveX Object Services
      • ▶Setup and Systems Management Services
      • ▶User Interface Services
      • ▶Windows Base Services
      • ▶Reference
    • ▶SDK Documentation
    • ▶DDK Documentation
    • ▶Windows Resource Kits
    • ▶Specifications
    • ▶Knowledge Base
    • ▶Technical Articles
    • ▶Backgrounders
    • ▶Books
    • ▶Partial Books
    • ▶Periodicals
    • ▶Conference Papers