You don't need a stored procedure to do this. The code you typed above is a simple union. It can be saved as a view. Just copy and paste the SQL code into whatever you used to create your queries (Query Manager, QMF, TOAD). Usually there's a menu that helps you with creating a view.
Here's an example of the code for creating a view:
CREATE VIEW VW_TEST1 AS
SELECT FIELD1, FIELD2, FIELD3,
WHERE FIELD1 = 'A'
This works in AS/400 Query Manager, MS SQL Server, Oracle, and QMF.
The only time I use a Stored Procedure is if I want to use a parameter on the server end and pass it to the Crystal Report. Views can be linked to other views and other tables within a Crystal Report unlike queries when used as data sources.