Are you refering to an SQL view to be used with SQL commands or a native Ligical file which would be used in RPG/COBOL reads.
If its SQL then you would do it with a union statement
As
Create view myview as
Select flda, fldb from lib1/file1
union
Select flda, fldb from lib2/file1

while this can be done in a native lf with multi-formats.
The native LF over multiple libraries can lead to some serious backup and restore issues.
Phil

It can be done as a native DDS JOIN LF, a multi-format LF or simply as a normal LF over multiple data members. Or it can be done as a SQL DML VIEW that JOINs or UNIONs multiple underlying TABLEs and/or VIEWs or as a simple cross-product “join”.

There are multiple possibilities with native or SQL methods. The appropriate technique might require seeing a sample of the tables and a description of final result.

Tom