I never learned SQL too well. A friend (who only uses Oracle) wrote some SQL for me, and I'm trying to translate it for MS Access. The SQL is:

SELECT a.id,
case when b.ufa is null then c.ufa
else b.ufa end as ufa
FROM metrotmp a,
(select mt.ID,mc.GEOID,mu.UFA
from metrotmp mt, metrocbsa mc, metroufa mu
where mt.ZIP = mc.ZIP
and mc.GEOID=mu.GEOID) b,
(select mt1.id, mu1.UFA
from metrotmp mt1, metroufa mu1
where mt1.STATE = mu1.GEO ) c
where a.id = b.id (+)
and a.id = c.id

I think there are three problems with this:

1. Access has no "case when"
2. Access has no "is null"
3. Access has no "(+)".

For #1, I think nested iif's will work.
For #2, I think nz() will work.

What exactly is (+)? How would I translate (+) into MS Access SQL?

Thanks!