[Tex/LaTex] Symbols for Outer Joins

databasesymbols

I'm looking for a way to typeset the symbols for outer joins, that is ⟕ U+27D5 onward.

There seems to be nothing in symbols-a4. Note that I'm not looking for ⋊ U+22C9 as this represents a semijoin.

This post presents a custom eps (for only one of the three symbols) and a anonymous comment suggests using an ifsym timing diagram (I'm awed by the lateral thinking but the result looks ugly).

Best Answer

\documentclass[a4paper]{article}
\usepackage{amssymb}

\def\ojoin{\setbox0=\hbox{$\bowtie$}%
  \rule[-.02ex]{.25em}{.4pt}\llap{\rule[\ht0]{.25em}{.4pt}}}
\def\leftouterjoin{\mathbin{\ojoin\mkern-5.8mu\bowtie}}
\def\rightouterjoin{\mathbin{\bowtie\mkern-5.8mu\ojoin}}
\def\fullouterjoin{\mathbin{\ojoin\mkern-5.8mu\bowtie\mkern-5.8mu\ojoin}}

\begin{document}
\[A\leftouterjoin B\]
\[A\rightouterjoin B\]
\[A\fullouterjoin B\]
\end{document}

example

Related Question