Re: SQL question

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.

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.