help with query in access
- by Gold
hi
i have 2 tables
Table A - code|name
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 try somthing like: update A set name = (select top 1 Name from B where B.Code = mid(A.Barcode,1,8))
but it dos't work