title: show different columns from different table with inner join
body: <p>Hi i have a lot of inner in a query but i can't print column in different table, for example:
  where</p>
  <pre><code>Table A
  id       f
  -----------
  xxx     gggg
  bbb     kkkk
  
  Table B
  name    code
  -----------
  ccc     dddd
  bbb     oooo
  </code></pre>
  <p>My code:</p>
  <pre><code>select A.id,A.F from (query1)as stima
  join
  (select B.name,B.code from B as aaaa query)as noome
  on noome.code=stima.F;
  </code></pre>
  <p>But if i want put name columns of B table in 'select A.id,A.F' how can i do?
  My output is id and colum F but i want output: id,F and name columns.</p>