<div>
This is what I meant, and why I like Inner Join statement it makes the code<br />
self-documenting, if you later have to go back and add a LEFT/RIGHT/FULL JOINs<br />
to a third table, it will allow you not to get the mixed-join-types error, but both forms COMMAS and JOINS deliver the same result.<br />
Your error &quot;cannot be bound&quot; is due to the alias your are updating Products and then in your from you have Products as a.. and yo do not need to use the alias in the set ...see set a.sizeenglish...see code :)<br />
&nbsp;<br />
<br />

<pre><code id="code-191883">update a
set sizeenglish= b.sizeenglish
from Products a 
INNER JOIN  Conversions b 
ON b.sizedecimal= a.sizedecimal</code></pre>
</div>


This is what I meant, and why I like Inner Join statement it makes the code
self-documenting, if you later have to go back and add a LEFT/RIGHT/FULL JOINs
to a third table, it will allow you not to get the mixed-join-types error, but both forms COMMAS and JOINS deliver the same result.
Your error "cannot be bound" is due to the alias your are updating Products and then in your from you have Products as a.. and yo do not need to use the alias in the set ...see set a.sizeenglish...see code :)
 



update a
set sizeenglish= b.sizeenglish
from Products a 
INNER JOIN  Conversions b 
ON b.sizedecimal= a.sizedecimal

<div>
<div class="content wysiwyg-content">
I have the following sql statement and I get a &quot;cannot be bound&quot; error.<br />
<br />
update Products <br />
set a.sizeenglish= b.sizeenglish<br />
from Products a , Conversions b <br />
where b.sizedecimal= a.sizedecimal<br />
<br />
the conversion table looks like this<br />
<br />
1&quot;, 2.54<br />
2 3/4&quot;, 5.625<br />
<br />
the decimal sizes in my products table are already populated.
</div>
</div>


I have the following sql statement and I get a "cannot be bound" error.

update Products 
set a.sizeenglish= b.sizeenglish
from Products a , Conversions b 
where b.sizedecimal= a.sizedecimal

the conversion table looks like this

1", 2.54
2 3/4", 5.625

the decimal sizes in my products table are already populated.

Updating one table with values from another

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.