Editing Join (SQL) (section)

====Alternative syntaxes====
Oracle supports the deprecated<ref name="deprecated_plus_sign">
[http://www.dba-oracle.com/tips_oracle_left_outer_join.htm Oracle Left Outer Join]</ref> syntax:
<syntaxhighlight lang="sql">
SELECT *
FROM employee, department
WHERE employee.DepartmentID = department.DepartmentID(+)
</syntaxhighlight>
[[Sybase]] supports the syntax ([[Microsoft SQL Server]] deprecated this syntax since version 2000):
<syntaxhighlight lang=tsql>
SELECT *
FROM employee, department
WHERE employee.DepartmentID *= department.DepartmentID
</syntaxhighlight>
[[IBM Informix]] supports the syntax:
<syntaxhighlight lang=sql>
SELECT *
FROM employee, OUTER department
WHERE employee.DepartmentID = department.DepartmentID
</syntaxhighlight>
[[File:SQL Join - 03 A Right Join B.svg|alt=A Venn diagram show the right circle and overlapping portions filled.|thumb|
A Venn diagram representing the right join SQL statement between tables A and B.
]]