SELECT 'US' FROM state WHERE state.code = temp.code
UNION ALL
SELECT country.code FROM country
WHERE NOT EXISTS(SELECT 'US' FROM state WHERE state.code = temp.code)
AND country.code = temp.code

HTH
- Nandu