Sql Update Query

[chelvan]

i have wrote the following sql, it works on ms access but not in sql server. say syntax error near inner. i could nt find out the error any help?

UPDATE rptLastPurchase Rate INNER JOIN STOCK ON rptLastPurchase Rate.ID = STOCK.ID SET rptLastPurchase Rate.Rate = [stock].[rate]

[chelvan]

i have done that.....
by change to
"update rptLastPurchase Rate set rptLastPurchase Rate.RATE=STOCK .RATE from rptLastPurchase Rate inner join STOCK on rptLastPurchase Rate.[id]=stock.[id]"