››

⟕

left outer join

Left outer join

⟕ means a left outer join: combine two tables while keeping every row from the left table, even if there is no match on the right. In relational algebra—a way to describe operations on tables—it does the job of SQL's LEFT OUTER JOIN. The relational model behind relational algebra was proposed by Edgar F. Codd in 1970.

Text symbol

Search it as: left join · outer join · relational algebra · SQL join · join operator · database symbol
Shows up in: Anything that takes text · its shape is whatever your font draws

What ⟕ means

⟕ is the left outer join. Unicode classifies it as a mathematical symbol and files it in the Miscellaneous Mathematical Symbols-A block; this site shelves it under Maths.

Its appearance depends on the font and text styling.

How it is encoded

⟕ is a single code point, U+27D5. In HTML that is ⟕, and in CSS \27D5.

Don't confuse it with

⟖

Right Outer Join

shares “join”, “outer”

⟗

Full Outer Join

shares “join”, “outer”

Questions people ask

Why does ⟕ show as a box on some devices?

Because that device's fonts have no glyph for it. The character is still correct and still copies correctly — the box is a missing glyph, not a broken character.

How to type ⟕

Windows (Word)

Alt+XType 27D5, then Alt+X to get ⟕.

Windows

Win+Rrun charmap for the full table, or use the emoji picker's Ω symbols tab (Win + .).

macOS

Control+Command+SpaceOpen the character viewer and search “left outer join”.

Linux

Ctrl+Shift+UType 27d5, then Enter or Space.

HTML

⟕

CSS

\27D5

Codes and encoding1 code points

HTML decimal

⟕

HTML hex

⟕

CSS content

content: "\27D5";

Each escape is closed by the next backslash; a trailing space is needed before a literal hex digit.

URL encoded

%E2%9F%95

On screen

Code points

JS .length

UTF-8 bytes

A visible symbol can contain several code points. JS .length counts UTF-16 units; UTF-8 counts bytes.

Families this belongs to

Maths & numbers1,835 symbols

1️⃣📏📐✖️➕➖➗🟰♾️#️⃣*️⃣0️⃣