title: How to left join column in other way
body: <p>I want to map right column to left but i am getting error at select statement as Incorrect syntax near 'select'.Expecting ID </p>
  
  <pre><code>create table [AdventureWorks2014].[abc] as
  select a.*,
          b.*
  from [Production].[Product] a
  left join(
  select distinct ProductID,Shelf
  from [Production].[ProductInventory]
  )b
  on a.ProductID = b. ProductID;
  </code></pre>