Hi, this is probably a really newb question since I'm pretty new to Crystal Reports, Oracle, and SQL, but here goes. I have two tables with the same fields but different information in them (for the curious, this is at a school and one table has information for the current year and the other has information for next year). I need to make a composite query that has the rows from each of the other tables, as well as an additional field that identifies which table the information came from. My SQL statement is:

SELECT *, "1" AS TABLE_CODE FROM TABLE1
UNION
SELECT *, "2" AS TABLE_CODE FROM TABLE2

But when I try to save it, I get "Error in compiling SQL expression: Query Engine Error: 'ORA-00936: missing expression'." I assume there's a problem with my SQL expression, but from what little I know (mostly from working in MS Access) it should work.

Any ideas? Thanks in advance for the help!