I have a simple UNION query
SELECT COUNT(Movies.ID) AS '1930s' from Movies WHERE Movies.[Release Year] BETWEEN '1930' AND '1939'
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