Re: Exchange Rate Conversions

[Peter Brawley]

Read again. You've put the From clause at the top of the query, where it doesn't belong, and repeated it after the select list. It needs to occur just once, right after the Select list (as shown).

Surrounding names with [] is SQL Server syntax. This is MySQL. As the manual explains pretty clearly, backticks (`) are required round names containing illegal chars (space, dash &c). So in all your queries, column names like `proj def`, `postg date` must be surrounded by backticks. Ugh. Do not use illegal chars in database object names, it just causes problems and makes errors much more probable.