Issues with updating a column

Question

Hi Team -

I have a table set up as such:

TableA
Project  | Compound
PFI-1111 | 

Table B
Parent Node | Name
PFC-1111    | PFI-1111

So what I need to do is insert 'PFC-1111' into Compound for TableA. 

Having trouble making that connection, can someone assist? Thank you so much!

Answer 1

Hi,

Not sure exactly what you're trying to do but have you tried something similar to this?

UPDATE TableA
INNER JOIN TableB
ON TableA.Project=TableB.[Name]
SET TableA.Compound=TableB.[Parent Node]

Answer 2

Thank you, worked great!

Answer 3

Thank you, worked great!

Hi,

You're welcome! Good luck with your project.