Originally posted by nandu
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
error it will not give required o/p

Abhay.