Get the matched column value of the global table from the temp table's field input
<p>I have created the temp table and stored the id of the customer.</p>

<p>Now I want to get the Name of the customer from the id of the temp table while inserting it into another table.</p>

<pre><code>Insert INTO Cust1 Values(Id, Name)
Values SELECT ID From @Temp (here from the specific id i want to insert the name.)
</code></pre>

<p>Thanks in advance</p>