Outer Join in SQL Server


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Outer Join in SQL Server

  1. #1
    Ritu Guest

    Outer Join in SQL Server


    How to wirte Outer Join in SQL Server?

  2. #2
    Douglas J. Steele Guest

    Re: Outer Join in SQL Server

    Like it says in BOL:

    SELECT employee.emp_id, employee.job_id
    FROM employee LEFT OUTER JOIN jobs
    ON employee.job_id = jobs.job_id
    WHERE (jobs.job_id IS NULL)

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele


    "Ritu" <rituchowdhary@yahoo.com> wrote in message
    news:3cc5f95c@10.1.10.29...
    >
    > How to wirte Outer Join in SQL Server?




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center