Answer

Update a raw row in staging

Hi! I am trying to update “Planned End Date” for a specified work order in staging.

I have prepared this table to join to my work order raw table:

This is my sql and the error message I got:

Is there a way I could update “Planned End Date”? Thanks in advance. :)

Best answer by Yanzhu Yu

Hi again! The issue is solved by using the following sql:

Hi again! The issue is solved by using the following sql:

Sign up