RE: JOIN with UNION

CREATE VIEW FILEALL 
 as ( SELECT * FROM FILE1 UNION ALL SELECT * FROM FILE2 )

HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx] 
> On Behalf Of Tomasz Skorza
> Sent: Thursday, May 25, 2006 4:44 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: JOIN with UNION
> 
> Hi
> 
> How to create "logical" files which will be equivalent for SQL code:
> 
> insert into LIB/FILEALL                             
> SELECT * FROM FILE1 UNION ALL SELECT * FROM FILE2
> 
> With Join statement I have to use some condition, so how to 
> union two or
> more files?
> 
> I can do it by sql but I would like to have FILEALL with 
> always "fresh"
> records?
> 
> Regards
> 
> Tomasz Skorza       
> 
> -- 
> 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.
> 
>