I get error SQL Msg 4104
<p>Using this code:</p>

<pre><code>UPDATE MyBase.dbo.Inventory
SET Inventory.BarCode= Table1.Barcode
FROM Market.dbo.Table1, MyBase.dbo.Inventory
WHERE Table1.Barcode=Inventory.BarCode 
</code></pre>

<p>I'm getting error message:Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "Table1.Barcode" could not be bound.</p>