Re: SQL question

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

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:

> I use Enterprise Reporting to make querys to PF files.
>
> In my ERP, i have repeat equals files in distint LIB,
> example:
>
> LIB1 -> File1
> LIB2 -> File2.
>
> Well, my questions is simple: ¿are there a way to make
> this using one view or index of two files?
> Like that, i can query to view that contains data from
> several equals files.
>
> I dont know if this is posible.
>
> Thanks.
>
>
>
>
> ______________________________________________
> 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.