I need to find what "Codes" from column "RMS_CODE" and column "RMS_ALT1_Cde" are not being used in the Child # (starting in position 6 for a length of 4) column within the "APC_Spec" number. I tried using the sql in the image provided, but it only looks in the row and doesn't check the whole column within the "APC_Spec" requirement. Can anyone suggest a method to check which codes are not being used per "APC_Spec" in the Child column #?
Asked by Maven BeJayjay
(13 rep)
Apr 30, 2020, 03:15 PM
Last activity: Aug 5, 2020, 07:51 PM
Last activity: Aug 5, 2020, 07:51 PM