Full Outer Join Symbol
⟗ represents a full outer join in relational database and query-style notation.
U+27D7
The symbol ⟗ is commonly associated with a FULL OUTER JOIN operation. It’s used to express how two datasets are combined while keeping unmatched rows from both sides. This page helps you copy the symbol and understand typical contexts where it appears.
Full Outer Join Symbol Meaning
⟗ (FULL OUTER JOIN) is a notation used in database querying to combine two tables or result sets. Unlike an inner join, it preserves rows that don’t match in either table. In practical terms, the output includes all rows from both inputs: matched pairs appear once, while unmatched rows from the left or right side are still included with missing values filled in for the other side. You may see it in SQL-like documentation, diagrams, or explanations of join behavior. It’s primarily technical notation rather than a general-purpose punctuation mark.
Common uses
- •Documenting SQL join behavior in tutorials and cheat sheets
- •Labeling nodes in database join diagrams and schema diagrams
- •Writing technical comments in code reviews about query logic
- •Formatting slide decks and reports that compare join types
- •Annotating data pipeline steps that merge datasets
Examples
⟗ Full Outer Join Symbol
- ⟗A ⟗ combines both matched and unmatched rows from Table A and Table B.
- ⟗Use ⟗ when you need a complete view of records across two sources.
- ⟗In the diagram, the merge step is marked with ⟗.
- ⟗The query returns all records using a ⟗ strategy for coverage.
- ⟗We switched from an inner join to ⟗ to avoid losing unmatched rows.
Variations
Ready to copy
Technical codes
| Unicode | U+27D7 | |
| HTML Entity | ⟗ | |
| HTML Code | ⟗ | |
| CSS | \27D7 | |
| Alt Code | Alt + 10199 | |
| Decimal | 10199 |
How to type Full Outer Join Symbol (⟗)
On Windows
Hold Alt and type 10199 on the numeric keypad. In Word, type 27D7 then press Alt + X.
On Mac
Switch to the Unicode Hex Input keyboard, then hold Option and type 27D7. Or press Control + Command + Space and search.
On Linux
Press Control + Shift + U, type 27d7, 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?
It denotes a FULL OUTER JOIN, which keeps all rows from both inputs, including those without matches.
Where will I commonly see ⟗ used?
You’ll typically see it in database documentation, SQL-related explanations, and join diagrams.
How do I copy ⟗ into my HTML page?
Use the HTML entity: ⟗
What is the CSS or JavaScript way to display ⟗?
CSS escape: \\27D7. JavaScript escape: \\u{27D7}.