Help with query in Microsoft 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 14:36 UTC
Read the original article Hit count: 160

Filed under:
|

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.

© Stack Overflow or respective owner

Related posts about ms-access

Related posts about sql