Hi, I'm Bhavik. Welcome to JustAnswer. I'm reviewing your question now, and will reply back ASAP.
I am so sorry, I have worked on it but don't know why my query is not visible here.
Select CLCP,CLCD from Key PEOPLE where County in (select county from CLC) and shortcode in (select shortcode from CLC);
Please use above query and see if it working as expected.
I am really very very sorry that you had to wait so long.
Did this help ?