select multiple column into a single row : <p>Suppose I've got two tables:</p>

<p>Table A:</p>

<pre><code>Item1Name  Item1Code  Item2Name   Item2Code
ABC         001         DEF          002
</code></pre>

<p>Table B:</p>

<pre><code>ItemCode     ItemType
  001        Cookware
  002         Drinks
</code></pre>

<p>What should the select statement be to generate following result?</p>

<pre><code>Item1Name  Item1Code  Item2Name   Item2Code   Item1Type    Item2Type
ABC         001         DEF          002       Cookware      Drinks
</code></pre>
