title: Will MVA work with text fields in Sphinx?
body: <p>I am indexing an id from a look-up-table in my <code>sphinx configuration</code>.</p>
  
  <pre><code>sql_attr_multi = uint customer_type_id from ranged-query; \
  SELECT f.orderID AS ID, f.typeID \
  FROM LUT_customerType f \
  WHERE f.orderID BETWEEN \$start AND \$end \
  ORDER BY f.orderID; \
  SELECT MIN(orderID), MAX(orderID) FROM LUT_customerType
  </code></pre>
  
  <p>this returns, for example, in a given field:</p>
  
  <p><code>customer_type_id: 3,5.15</code></p>
  
  <p>As the LUT table simply stores <code>orderID</code> and <code>typeID</code></p>
  
  <p>However, I now want to index the Type Name (I was using MySql to query it but this will be more efficient I hope).</p>
  
  <p>I tried doing this:</p>
  
  <pre><code>sql_joined_field = customer_type_name from ranged-query; \
  SELECT f.orderID AS ID, n.Name \
  FROM LUT_customerType f \
  INNER JOIN customerType_Names n ON f.typeID= n.ID \
  AND f.orderID BETWEEN \$start AND \$end \
  ORDER BY f.orderID; \
  SELECT MIN(orderID), MAX(orderID) FROM LUT_customerType
  </code></pre>
  
  <p>In other words, I replicated the working <code>MVA</code> <code>Select</code> with two minor changes:</p>
  
  <ol>
  <li>I added an additional join to get the Type Name</li>
  <li>I removed the unit since I didn't want this to be an integer</li>
  </ol>
  
  <p>I tried the <code>Select</code> in MySql and it works as expected.</p>
  
  <p>Yet neither the field nor values show up, not in individual records when selecting from <code>SphinxQL</code></p>
  
  <pre><code>`Select * from idx_Table`
  </code></pre>
  
  <p>Nor when checking the Sphinx Index Structure</p>
  
  <pre><code>`Desc idx_Table`
  </code></pre>