Help with query in Microsoft Access

I have 2 tables:

1. Table A: code | name

2. Table B: barcode | name

Table B has full barcode and name, 开发者_如何转开发Table A has only code.

I need to run update query that fill name in Table A.

I tried something like:

update A set name = (select top 1 Name from B where B.Code = mid(A.Barcode,1,8))

but it doesn't work.

Name is a reserved word, you need to put it in square brackets: [name]

In general, fields (columns) should not be named with reserved words.

List of reserved words in Access 2002 and in later versions of Access