Hey all,

Im just wondering if its possible to do an INNER JOIN while using an UPDATE statement, something like the following:

Code:
    UPDATE
        Description d
    SET
        d.Text = "Hello World"
    INNER JOIN
        Item i ON d.ItemID = i.ItemID
    WHERE
        i.ImportID = 5
Basically, I have something like the following:

Item
----------
ItemID
ImportID

Description
-----------
DescriptionID
ItemID
Text

I have an importID, and I want to update the description of the item with this importID.

Am I on the right track?

Thanks,
Matt.