[dba-SQLServer] Union query

Please be kind.  I am doing this from an Access viewpoint and am having
trouble making a transition.

I have created a union query:

Select *

>From     dbo.schoolEnrollmentNumberselemonly  (this is a view)

Union all

Select *

>From     dbo.SchoolEnrollmentNumberselemcombo (this is a view)

 

Now I need to be able to call this query in another view.  Is this possible?
How?

 

Susan Klos

Senior Database Analyst

Evaluation and Reporting

Florida Department of Education

850-245-0708 

sc 205-0708