sql - Syntax error when updating -

i'm bit of noobie when come sql, i'm using access 2013 , i'm trying update date field in 1 table, using id numbers different table update specific ones.

the query have is:

update leadsavailable set first_usage_date = '23/04/2014' leadsavailable r inner join workingtable_gosh g     on g.[lead number] = r.[lead number]  g.type = 'gosh' 

but keep getting errors , don't know why.

any appreciated

try sorry im in mobile:

update leadsavailable inner join workingtable_gosh b on a.[lead number] = b.[lead number] set a.[first_usage_date] = '23/04/2014' b.type = 'gosh';