hoseam (8/25/2014)
Yes Scheme Code is s_code is the table.
OK, but none of the codes - error_code or schema_code - from the sample data appear in your result set.
Why is this?
To me it seems you could just query your table like this:
SELECT DISTINCT schema_code, error_code
FROM error_staging;
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP