Full Outer Join

Part of Math Symbols

Full 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+27D7

About this symbol

⟗ is the full outer join of relational algebra, which keeps every row from both tables, filling in blanks where there is no match. SQL writes it FULL OUTER JOIN.

Unicode facts

Official name
FULL OUTER JOIN
Type
Maths symbol
Unicode block
Miscellaneous Mathematical Symbols-A
Unicode group
Database theory operators
Added in
Unicode 3.2 (2002)
Related
⨝ Join U+2A1D

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.