I would like to be able to accomplish the following but don't see any support for inner joins on update queries.
update A set Id = B.Id from A inner join B on A.Field1 = B.Field_Temp where B.Price > 0 Is this possible? What is the syntax of this query please?