SQL logic needed

I’m stuck at the point where I need to create a new column for quantity where my quantity should always be the one associated with material type = HAL.
Please find the screenshot attached.
I would appreciate if someone helps me with a SQL code to achieve the desired result.

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.