Left Outer Join Symbol
⟕ represents a LEFT OUTER JOIN in common math and query notation.
U+27D5
The symbol ⟕ represents a LEFT OUTER JOIN. It’s commonly used in mathematical or database-notation contexts to describe how rows are matched and preserved from the left side. You can copy it directly or use its Unicode code point U+27D5.
Left Outer Join Symbol Meaning
⟕ is the “LEFT OUTER JOIN” symbol. In join operations, a left outer join combines rows from two data sets based on a matching condition, keeping all rows from the left (first) side even when there is no match on the right. Unmatched left rows typically show null or empty values for the right side fields. This character is most useful when writing or typesetting formal query expressions, relational algebra, or documentation where a visual join operator is clearer than words. If you’re working in SQL, you’ll usually write LEFT JOIN, but ⟕ can appear in diagrams, specs, or mathematical presentations.
Common uses
- •Documenting SQL join logic in technical guides and tutorials
- •Relational algebra or database theory notes and diagrams
- •Describing query behavior in API or system documentation
- •Annotating comparison tables of INNER vs OUTER joins
- •Creating consistent math/engineering notation in reports and specs
Examples
⟕ Left Outer Join Symbol
- ⟕LEFT OUTER JOIN keeps all rows from the left table ⟕ matches.
- ⟕In relational algebra, A ⟕ B selects all A rows with matching B data.
- ⟕Use ⟕ when you want missing right-side matches to stay visible.
- ⟕Our report uses ⟕ to include rows even if the lookup table has no entry.
- ⟕Compare INNER JOIN (matching only) vs ⟕ (keep left rows).
Variations
Ready to copy
Technical codes
| Unicode | U+27D5 | |
| HTML Entity | ⟕ | |
| HTML Code | ⟕ | |
| CSS | \27D5 | |
| Alt Code | Alt + 10197 | |
| Decimal | 10197 |
How to type Left Outer Join Symbol (⟕)
On Windows
Hold Alt and type 10197 on the numeric keypad. In Word, type 27D5 then press Alt + X.
On Mac
Switch to the Unicode Hex Input keyboard, then hold Option and type 27D5. Or press Control + Command + Space and search.
On Linux
Press Control + Shift + U, type 27d5, then press Enter or Space.
Anywhere
Copy ⟕ with the button above and paste it wherever you need it — this works on every device and in every app, with no keyboard shortcut to remember.
FAQ
What does the symbol ⟕ mean?
⟕ is the Unicode symbol named “LEFT OUTER JOIN” (U+27D5), used to represent a left outer join operation.
Is ⟕ the same as SQL LEFT OUTER JOIN?
Yes. In typical database notation, ⟕ corresponds to the LEFT OUTER JOIN idea: all left rows are kept, with unmatched right values treated as NULL.
How can I copy ⟕ for use in text or code?
Copy the character directly (⟕). You can also use its Unicode code point U+27D5 or the escapes: CSS \27D5 and JavaScript \u{27D5}.
Where is ⟕ commonly used besides SQL?
It appears in relational algebra, database theory documentation, technical writing, and diagrams that compare join types.