Why would this query:
-----------------------------------------------
SELECT S.*
FROM SIMULATOR S
WHERE S.ClientID=13 AND (S.recordType=0) OR (S.recordType=2) OR
(S.recordType=100)

UNION ALL

SELECT S.*
FROM SIMULATOR S
WHERE S.ClientID=13 AND (S.recordType=0)
--------------------------------------------

produce the error
------------------------
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Invalid command
count of column list and variable list do not match
---------------------

The two queries work fine if run individually without the union.

Thank you