Avoid creating view

Last Post 29 Oct 2007 09:24 AM by roma. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
roma
New Member
New Member

--
29 Oct 2007 07:23 AM
Hi ,

I try to find distinct name from 2 similar tables .
For example I have Customer1 (cusID, custName) and Customer2 (cusID, custName).

I did:
Create View allCust as
Select * from Customer2
Union All
Select * from Customer1

Select distinct(custName) from allCust.

My question : is there the way to get the result without crating a view?

Thank you.



roma
New Member
New Member

--
29 Oct 2007 09:24 AM
Thank you
You are not authorized to post a reply.

Acceptable Use Policy