title: MySQL Syntax error message "Operand should contain 1 column(s)"
body: <p>I tried running the following statement:</p>
  
  <pre><code>INSERT INTO VOUCHER (VOUCHER_NUMBER, BOOK_ID, DENOMINATION)
  SELECT (a.number, b.ID, b.DENOMINATION) 
  FROM temp_cheques a, BOOK b
  WHERE a.number BETWEEN b.START_NUMBER AND b.START_NUMBER+b.UNITS-1;
  </code></pre>
  
  <p>which, as I understand it, should insert into VOUCHER each record from temp_cheques with the ID and DENOMINATION fields corresponding to entries in the BOOK table (temp_cheques comes from a database backup, which I'm trying to recreate in a different format). However, when I run it, I get an error:</p>
  
  <pre><code>Error: Operand should contain 1 column(s)
  SQLState:  21000
  ErrorCode: 1241
  </code></pre>
  
  <p>I'm running this in SQuirrel and have not had issues with any other queries. Is there something wrong with the syntax of my query?</p>
  
  <p>EDIT:</p>
  
  <p>The structure of BOOK is:</p>
  
  <pre><code>ID  int(11)
  START_NUMBER    int(11)
  UNITS   int(11)
  DENOMINATION    double(5,2)
  </code></pre>
  
  <p>The structure of temp_cheques is:</p>
  
  <pre><code>ID  int(11)
  number  varchar(20)
  </code></pre>