update joined table

[Cyrus]

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

[dglienna]

You have to update table2 or table1?

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

[GremlinSA]

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

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...