I need to do a simple select of email and country but the country has to be the output of a lookup table that cleans up country values in our data. I'm not sure how to code the lookup piece (between asterixs below)
select c.email,
*** Lookup c.country IN CountryCodeValues retrieve lk.country ***
as country
FROM
TABLE c
LEFT JOIN should have worked too. If you use LEFT JOIN, you will get records from TableC even if there is no countrycode (which is probably what you want)