Left Outer Join

Part of Math Symbols

Left Outer Join has no standard Windows Alt code. Copy the character directly, or use its HTML entity or Unicode value instead.

Alt code
None
HTML entity
⟕
Unicode
U+27D5

About this symbol

⟕ is the left outer join of relational algebra: it combines two tables like the natural join ⋈, but keeps every row of the left table even when it has no match. SQL writes it LEFT OUTER JOIN.

Unicode facts

Official name
LEFT OUTER JOIN
Type
Maths symbol
Unicode block
Miscellaneous Mathematical Symbols-A
Unicode group
Database theory operators
Added in
Unicode 3.2 (2002)

Click the symbol or any value at the top of the page to copy it. See the full Math Symbols chart for related characters.

Cookie preferences

Choose which optional cookies you allow. You can change your choice at any time from Cookie Settings at the bottom of every page. Read the Cookie Notice

Necessary Needed for the site to work and to remember your cookie choice. Always on.