In the RRBYW20 sample database, the "QuarterlySummary" view example utilizes three UNION statements with an initial SELECT statement. The following instructions will step through the process to recreate the view in the Query Builder.
To continue, launch R:BASE 11 and connect to the RRBYW20 sample database. The database is located in the following default installation directory: "C:\RBTI\RBG11\Samples\RRBYW20".
1.Start R:BASE
2.Connect to the RRBYW20 sample database, by selecting "Database" > "Connect", and navigating to the above default installation directory based upon your version.
3.Then, launch the Query Builder by selecting "Tools" > "Query by Example" from the main menu bar