• Thanks
    starting with...
    /* Joining on Prod_Class */
    left JOIN [TSC].[EMS_TVC_PROD_CLASS] C
    ON #TEMP1.PD_ID = C.[PROD_ID]

    I need the value (Class_value_1) from Prod_Class where #TEMP1.PD_ID = C.[PROD_ID] 

    I appreciate the reply.