title: insert into select query-multipart identifier could not be bound
body: <p>this query returns multipart identifier could not be bound for </p>
  
  <pre><code>table2.AId and  table1.LId = table2.LId
  </code></pre>
  
  <p>the query is</p>
  
  <pre><code>insert into table1(col1)
  select col2 from table2
  where table1.AId = table2.AId and  table1.LId = table2.LId;
  </code></pre>
  
  <p>your help is highly appreciated</p>