help with query in access

Posted by Gold on Stack Overflow See other posts from Stack Overflow or by Gold
Published on 2010-03-08T09:18:03Z Indexed on 2010/03/08 9:21 UTC
Read the original article Hit count: 251

Filed under:
|

hi

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 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

© Stack Overflow or respective owner

Related posts about access

Related posts about query