Re: Help in SQL

[MWalter@xxxxxxxxxxxxxxx]

Either :

 Select a.field1, b.field2,c,field3 from file1 a, file2 b, file3 c where
a.key1 = b.key2 and a.key1 = c.key3

or

Select a.field1, b.field2,c,field3 from file1 a join file2 b on a.key1 =
b.key2 join file3 c on a.key1 = c.key3

Hope this helps.

Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040



                    "Giri Gopal"
                    <GiriGopal@bcginK        To:     <rpg400-l@midrange.com>
                    .com>                    cc:
                    Sent by:                 Subject:     Help in SQL
                    rpg400-l-admin@mi
                    drange.com


                    08/30/01 05:42 PM
                    Please respond to
                    rpg400-l







 Hello:

I want to join 3 physical files. Can some one help in the syntax of
creating
an SQL statement to join 3 physical files.


Thanks
GG

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.