I try to find distinct name from 2 similar tables .
For example I have Customer1 (cusID, custName) and Customer2 (cusID, custName).
Create View allCust as
Select * from Customer2
Select * from Customer1
Select distinct(custName) from allCust.
My question : is there the way to get the result without crating a view?