Right Outer Join Symbol
⟖ denotes a right outer join, matching all rows from the right table with optional matches from the left.
U+27D6
The symbol ⟖ is the “right outer join” notation. It’s commonly used in math-style writing to describe how two datasets are combined. Use it in docs, diagrams, and code-related notes when you want a clear join operation label.
Right Outer Join Symbol Meaning
⟖ (U+27D6) is the Unicode symbol named “RIGHT OUTER JOIN.” In join operations, a right outer join returns every row from the right-side table, including those that have no matching row on the left. Where matches exist, the combined fields from both sides are included; where they don’t, the left-side fields are typically treated as missing (often shown as NULL in database contexts). This makes ⟖ a compact way to document data transformation logic in educational materials, technical diagrams, and standardized pseudocode.
Common uses
- •Labeling join steps in database query diagrams and ETL workflows
- •Documenting right-preserving merge behavior in analytics notes
- •Teaching relational concepts in math-notation style exercises
- •Annotating schema or transformation documentation in technical writing
- •Writing readable pseudocode for systems that describe joins formally
Examples
⟖ Right Outer Join Symbol
- ⟖SELECT ... FROM left L RIGHT OUTER JOIN right R ...
- ⟖Result = left ⟖ right (keep all rows from the right).
- ⟖Diagram step: apply ⟖ between Customers and Orders.
- ⟖For unmatched rows on the left, output still appears via ⟖.
- ⟖In this transform, use ⟖ so every right item is retained.
Variations
Ready to copy
Technical codes
| Unicode | U+27D6 | |
| HTML Entity | ⟖ | |
| HTML Code | ⟖ | |
| CSS | \27D6 |
FAQ
What does the ⟖ symbol mean?
⟖ means “right outer join,” returning all rows from the right dataset with matching information from the left when available.
What is the Unicode code point for ⟖?
The symbol ⟖ has Unicode code point U+27D6.
How can I copy ⟖ into HTML?
Use the HTML entity: ⟖.
How do I use ⟖ in CSS or JavaScript?
CSS escape: \\27D6. JavaScript escape: \\u{27D6}.