Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Queries/Views > Query Builder > Technical Documents > Building a Query Using a Union > Quarterly Summary Query

Save the Query as a View

Scroll Prev Top Next More

To display the alias values, first save the query.

 

1.From the main menu bar, select "File" > "Save Query As View..."

2.In the dialog, enter "QuarterlySales2018" within the "View Name:" field.

3.In the dialog, enter "2018 Quarterly Sales Figures" within the "View Comment:" field.

4.Select the "OK" button.

5.Close the Query Builder by selecting "File" > "Close" from the menu bar.

 

In the Database Explorer, the view will be displayed with the name, comment, and number of columns