UNION crash

Avatar
Ian Eales
  • updated
  • Under review

I have a simple UNION query

SELECT COUNT(Movies.ID) AS '1930s' from Movies WHERE Movies.[Release Year] BETWEEN '1930' AND '1939'

UNION

SELECT COUNT(Movies.ID) AS '1940s' from Movies WHERE Movies.[Release Year] BETWEEN '1940' AND '1949'

On the first run, I get an error

Invalid SELECT statement.
Unexpected token "Select" at line 1, pos 16

On the 2nd attempt, FSsql crashes.

Same result with 

SELECT '1930s ' & COUNT(Movies.ID) AS 'Decade' from Movies WHERE Movies.[Release Year] BETWEEN '1930' AND '1939'
union
SELECT '1940s ' & COUNT(Movies.ID) AS 'Decade' from Movies WHERE Movies.[Release Year] BETWEEN '1940' AND '1949'