update joined table

I have join two tables using inner join as

select A.*,B.fld1 from table1 as A inner join Table 2 as B on A.fld=B.fld

the problem is i need to update a fldname on table1, but my app crashes after it updated the fldname

any suggestions.

rgds
cyrus

You have to update table2 or table1?

Post the code that you have tried, along with the error number, line, and message.

I'm sure a simple Update inner join statement will work..

Code:

---

Update Table1 as A
Inner Join Table 2 as B on A.fld=B.fld
Set A.fld = @newdata,
B.fld = @newdata
Where
A.fld = @olddata

---

Gremmy...