none
Issues with updating a column RRS feed

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



    • Edited by cdtakacs1 Monday, January 14, 2019 4:34 PM
    Monday, January 14, 2019 4:33 PM

Answers

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

    • Marked as answer by cdtakacs1 Tuesday, January 15, 2019 8:56 PM
    Monday, January 14, 2019 4:38 PM

All replies

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

    • Marked as answer by cdtakacs1 Tuesday, January 15, 2019 8:56 PM
    Monday, January 14, 2019 4:38 PM
  • Thank you, worked great!
    Tuesday, January 15, 2019 8:56 PM
  • Thank you, worked great!

    Hi,

    You're welcome! Good luck with your project.

    Tuesday, January 15, 2019 9:39 PM