title: Want to concatenate column of the second query to the first query but getting errors such as "query block has incorrect number of result columns"
body: <pre><code>SELECT
      ID, PRIM_EMAIL, SEC_EMAIL, PHONE 
  FROM
      STUDENTS.RECORDS
  WHERE 
      ID IN (SELECT ID FROM STUDENTS.INFO WHERE ROLL_NO = '554')
  
  UNION
  
  SELECT NAME 
  FROM STUDENTS.INFO 
  WHERE ROLL_NO = '554';
  </code></pre>
  <p>Here <code>Roll_No</code> is a user inserted data so for now I have hard coded it. Basically with the help of <code>ROLL_NO</code> I sort the <code>STUDENTS_INFO</code> table from where I get the <code>ID</code> and based on that I try to get <code>PRIM_EMAIL</code>, <code>SEC_EMAIL</code>, <code>PHONE</code> from the <code>STUDENTS.RECORDS</code> table while matching the foreign keys of both the tables. In addition to the current result set I also want to have the prov_name column.</p>
  <p>Any help is very much appreciated. Thank you!</p>