Update field from table A to table B

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to construct a query that will update the cost in table B with the
cost from table A.

How do I do this, please?

Thank you - Suz
 
UPDATE TableB INNER JOIN TableA ON TableB.TableB_ID = TableA.TableA_ID SET
TableB.TableB_Cost = [TableA_Cost];

- Raoul
 
Hi Raoul - thank you for replying but I think I misstated my question.

I need to REPLACE the cost information in table B with the cost information
from table A, where the joined fields are equal.

Will this change your answer?

I'm grateful for any assistance.

Suz

JaRa said:
UPDATE TableB INNER JOIN TableA ON TableB.TableB_ID = TableA.TableA_ID SET
TableB.TableB_Cost = [TableA_Cost];

- Raoul

Suz said:
I need to construct a query that will update the cost in table B with the
cost from table A.

How do I do this, please?

Thank you - Suz
Click to expand...
Click to expand...
 
No this should do the same.

- Raoul

Suz said:
Hi Raoul - thank you for replying but I think I misstated my question.

I need to REPLACE the cost information in table B with the cost information
from table A, where the joined fields are equal.

Will this change your answer?

I'm grateful for any assistance.

Suz

JaRa said:
UPDATE TableB INNER JOIN TableA ON TableB.TableB_ID = TableA.TableA_ID SET
TableB.TableB_Cost = [TableA_Cost];

- Raoul

Suz said:
I need to construct a query that will update the cost in table B with the
cost from table A.

How do I do this, please?

Thank you - Suz
Click to expand...
Click to expand...
Click to expand...
 
Back
Top