Re: Exchange Rate Conversions

[Keith Olsby]

Can you see anything wrong with my query? I am getting a cannot parse error.
my tables and field names are a little different since I renamed them initially for clarity. Do field names with spaces need [] around them in sql?

from dbo.C4ISR_Actuals a
join dbo.exchangerates x
on a.objcur=x.source
and a.postg date between x.valid-from and x.valid_to
select
a.proj def,
if(a.objcur='USD',
a.val objcur,
round(a.value objccur / x.exchangerate, 2)
) as amount
from dbo_C4ISR_Actuals a
join dbo_exchangerates x
on a.objcur=x.source
and a.postg date between x.valid_from and x.valid_to
order by a.Proj Def;