Re: SQL question

Glad it helped.
Vern

At 02:11 PM 7/4/2005, you wrote:

Thanks Vernon!

it´s a great tip.
The only that i need is:

create view allFiles as
select fields from lib1/file1
union
select fields from lib2/file2
union
select fields from lib3/file3
..

and when i make a query about allFiles, i have all
fields of all lib.


 --- Vernon Hamberg <vhamberg@xxxxxxxxxxx> escribió:

> If I understand correctly, you want to combine data
> from more than one
> file. Not a join, right? This is usually done with
> UNIONs
>
> select fields from lib1/file1
> union
> select fields from lib2/file2
> union
> select fields from lib3/file3
>
> You can have WHERE and GROUP BY in each SELECT
> sub-statement.
>
> You can have an ORDER BY, but only one, and it must
> come at the end.
>
> The fields in each SELECT must be compatible as to
> data type, but if you
> mean duplicate files, this is not a problem, right?
>
> Hope I got it right!
>
> Vern
>
> At 10:20 AM 7/4/2005, you wrote:
>
>



______________________________________________
Renovamos el Correo Yahoo!
Nuevos servicios, más seguridad
http://correo.yahoo.es
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.