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