• ▼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