title: How to join my table with information_schema.columns
body: <p>i need to join my table with information_schema.columns to get data type for all column.</p>
  
  <p>my sql is following.</p>
  
  <pre><code>select stock_code,automatic,semiautomatic,manual from VehicleInfoForParts
  </code></pre>
  
  <p>i want to join my VehicleInfoForParts with information_schema.columns to get a output like</p>
  
  <pre><code>Column_Name       Value               datatype
  -------------     -------            --------------             
  stock_code           A112                varchar
  automatic            1                   bit
  semiautomatic        0                   bit
  manual               1                   bit
  </code></pre>
  
  <p>please advise. thanks .</p>