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 libnam开发者_如何学Ce ='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 :))
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
精彩评论