<div>
it indicates an outer join.<br />
<br />
your &quot;d&quot; table is outer joined to your &quot;n&quot; table
</div>


it indicates an outer join.

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

<div>
<div class="content wysiwyg-content">
I am trying to analyze a query that has a Where clause that is formatted like this:<br />
<br />
WHERE n.dept_id=d.dept_id(+)<br />
<br />
What does the (+) mean?<br />
<br />
Thanks!
</div>
</div>


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?

Thanks!

SQL - Where Clause includes (+)

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.