Joining sql views in oracle sql

How can I join views using sql? I'm using Oracle at the moment?

Sql view 1

CREATE VIEW florence_staff AS
SELECT *
FROM staff
WHERE libname ='florence'

Sql view 2

CREATE VIEW alexandria_staff AS
SELECT *
FROM staff
WHERE libname ='alexandria'

I'm doing this to check if the fragmentation is correct, if you get what i mean. Thanks :))

Answers


These will be distinct result sets as the libname is different so use UNION ALL rather than UNION

SELECT * FROM florence_staff
UNION ALL
SELECT * FROM alexandria_staff

Need Your Help

Where (exactly) should i use synchronization in my Java EE application

java multithreading java-ee synchronized volatile

I am developing a content management system for game reviews using Java EE.

Seg fault when saving data using boost::serialization

c++ boost segmentation-fault boost-serialization

When trying to save the database using boost serialization, I encounter the segfault that I could not resolve. Would you please help? Any suggestion is greately appreciated.