Im just wondering if its possible to do an INNER JOIN while using an UPDATE statement, something like the following:
Basically, I have something like the following:Code:
d.Text = "Hello World"
Item i ON d.ItemID = i.ItemID
i.ImportID = 5
I have an importID, and I want to update the description of the item with this importID.
Am I on the right track?