Select Right operand to apply a function or unary operator to the right operand you have specified in the Right operand field or to specify a nested SELECT statement for the right operand.

To apply a function or unary operator to the right operand, from the Right operand cascaded menu, select the function or unary operator. The Right operand field will be replaced with the expression that results from applying the function or unary operator to the right operand you have specified.

To specify a nested SELECT statement for the right operand, from the Right operand cascaded menu, select Nested SELECT and then the type of nested SELECT statement you want to specify. The Right operand field will be replaced with a nested SELECT statement once you have specified one.

If an operator is not specified in the Operator field, Right operand is not available.