Have a scenario where a field has to be created based on a general part basis and then that field needs to be updated based on a more specific basis. Thought that the process could be done using left joins as follows but that is not the case. Have a workaround, but wondering if there is another way along these lines. Thanks.
//add the class by part (General)
GGPN AS Part,
GCLASS AS Class
// add the class by parent number & part number (Specific)