U+27D7 "⟗" Full Outer Join Unicode Character

U+27D7 "⟗" Full Outer Join is a mathematical and database notation symbol representing a full outer join operation in relational algebra, which combines rows from two tables where the join condition is met on both sides, while also including unmatched rows from each table with null values in the corresponding columns from the other table. This character, part of the Miscellaneous Mathematical Symbols-A block, serves as a concise visual representation in formal logic, set theory, and database query diagrams, distinguishing the full outer join from its left and right outer join counterparts. Its design typically features a circle with a plus sign inside, symbolizing the inclusive union of all matching and non-matching data elements.