Unanswered: ORA-00936 when I try to save my SQL statement
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
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.