title: USING keyword in Mysql
body: <p>I have a table A with the following definition in MySQL</p>
  
  <pre><code>----------------------------------
  id    c_id     t_id
  -------------------------------
  </code></pre>
  
  <p>where c_id references cid on another table B with the following definition</p>
  
  <pre><code>================================================
  id cid cname
  =================================================
  </code></pre>
  
  <p>So i am issuing the following query</p>
  
  <pre><code>select group_concat(cname) as list
  from A join B using (cid)
  where t_id="something";
  </code></pre>
  
  <p>But I m getting the following error</p>
  
  <pre><code>Unknown column "cid" in from clause
  </code></pre>
  
  <p>I tried changing it to "c_id", but that doesnt seem to work either..</p>
  
  <p>Any help is appreciated.</p>
  
  <p>Thanks</p>