Help on the Nearby Loci table definition

To change the search range from the default +/- 10 cM,

Explanation

The condition "\%6 > [\%3 - 10] AND \%6 < [\%3 + 10]" means "the value in column 6 is greater than [(the value in column 3) minus 10], and less than [(the value in column 3) plus 10]".

Apologies for the ugliness of the syntax. This is an advanced feature that's only needed for certain complex queries like this one. But if you do find a need for it in some other context, this is the rule: comparisons and arithmetic on the values of columns can be performed by specifying the column number with "\%", e.g. "\%2" for the value of column 2.