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 |
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}.