Dear Experts

I have following codes

text TO cmd noshow
select code,name
 from sale
ENDTEXT

if sqlexec(con,cmd,'table1')<0
	aerror(laerror)
	messagebox(laerror[1,2])
	return
endif


table2="crs"+sys(2015)
select * from table1 into cursor table2 readwrite

Now I want to update table2.name with sqlserver table master like this

update table2.name=master.name from master where table2.code=master.code

how is it possible?