SQL - Where Clause includes (+)

Posted on 2011-10-20
Medium Priority
Last Modified: 2012-08-13
I am trying to analyze a query that has a Where clause that is formatted like this:

WHERE n.dept_id=d.dept_id(+)

What does the (+) mean?

Question by:oneDayAtaTime
  • 2
LVL 28

Assisted Solution

omgang earned 200 total points
ID: 37001858
It indicates a one to many relationship.
OM Gang
LVL 74

Expert Comment

ID: 37001859
it indicates an outer join.

your "d" table is outer joined to your "n" table
LVL 74

Accepted Solution

sdstuber earned 1800 total points
ID: 37001874
to correlate to ANSI syntax

eslect * from n,d
where n.dept_id = d.dept_id(+)

is equivalent to....

select * from n
left outer join d
on  n.dept_id = d.dept_id


Author Closing Comment

ID: 37002627
Thank you!!!

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question