× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. April 2007

Re: SQL, Logical Files, Unions & Indexes.

<snip>
I will try to live with this, but the problem is that a Union is a View
.
And one cannot create Joins over 2 or more Views, can you?
</snip>

Union are not views. They are a way to run individual SQL statements and
have the result of each query stuck together. They can in a ordinary SQL
statement or in a view.

Select 1
Union
Select 2
Union
Select 3

Etc.

The only requirement is the output of each query must be compatible, ie
the same type and size for each field output.

I still am wondering if that cannot just be done in a stored procedure.




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.