››

⟗

full outer join

Full outer join

⟗ marks a full outer join: matching rows from two tables combine, and rows with no match on either side still appear. In relational algebra, a notation for table operations, it is the join operator; SQL normally spells it FULL OUTER JOIN. Missing columns for an unmatched row are null.

Text symbol

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

What ⟗ means

It keeps matched and unmatched rows from both tables. A relation is a table of rows. The join's matching condition pairs rows; any row without a partner stays in the result, with nulls in the missing columns.

Full outer join vs left outer join: the full join also keeps unmatched rows from the right. Compared with a right outer join, it also keeps unmatched rows from the left.

Technical notation for a table operator, used in relational algebra.

In SQL syntax, write FULL OUTER JOIN; ⟗ names the operation in relational algebra.

Don't confuse it with

⟕

Left Outer Join

shares “join”, “outer”

⟖

Right 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 27D7, 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 “full outer join”.

Linux

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

HTML

⟗

CSS

\27D7

Codes and encoding1 code points

HTML decimal

⟗

HTML hex

⟗

CSS content

content: "\27D7";

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

URL encoded

%E2%9F%97

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️⃣