subscript for a join (\bowtie) operation in LyX/LaTeX

I'm using LyX to write some R开发者_JAVA百科elational Algebra queries. I'm using the \bowtie symbol for the join operation but when I try to put a text in subscript directly under the symbol, I get the following error:

...a_{\t{pId}}\t{person}\right)\bowtie\limits {\t{pId}{1}=\t{pId}_{2}... I'm ignoring this misplaced \limits or \nolimits command.

Anyone knows how to do what I want? Preferably in LyX, but ERT code snippets will also be appreciated. Thanks!

Edit: \t is a macro for \text.

Better use

\Join

It works fine for me

Your problem is that \bowtie is not math operator such as \int, \sum etc.

Try this in preamble:

\usepackage{amsmath}
\DeclareMathOperator*{\btie}{\bowtie}

and this in document:

\(\btie\limits_{subscript}^{superscript}\)

I hope it's what you're looking for.

From http://en.wikibooks.org/wiki/LaTeX/Advanced_Mathematics#Above_and_below:

In preamble:

\usepackage{amsmath}

In equation:

\underset{your_subscript_here}{\bowtie}