Updating col from one table to another

[naveen327]

Hi I have imported two different CSV files (A.csv and B.csv) into two different tables (tbl_A and tbl_B) respectively using a VBA Import function.

When I try to update a col_product (which is empty) in tbl_A with data from col_product in tbl_B on a inner join between column concat in tbl_A and col_concat in tbl_B.

My update query looks like this
UPDATE tbl_A SET tbl_A.Product = (SELECT tbl_B.Product
FROM tbl_B INNER JOIN tbl_A ON tbl_A.Concat=tbl_B.Concat);

The select subquery within the update returns 488 rows with the products but when I run the update query it shows 488 rows which are blank?

Note: Should I be telling the update query exactly which rows to update on in tbl_A? The problem with that is the primary key for both tables is an autonumber.

Any help would be much appreciated.
Thanks, Naveen

 

[Joe4]

I created the query myself and tested it out and it seems to work. Here is the SQL that the Query Builder built that works:

UPDATE tbl_A 
INNER JOIN tbl_B 
ON tbl_A.Concat = tbl_B.Concat 
SET tbl_A.Product = [tbl_B]![Product];

 

[naveen327]

Hi,

Sorry for posting twice, I'll check more carefully next time also thanks for the reply your query worked well.

I realised the problem was with one of the fields i am using in the join which is not a pk in one of the tables.