jrn

How the journalling differs frm triggers?
murail

On Sat, 26 Oct 2002 BrgttHsr@aol.com wrote :

--
[ Picked text/plain from multipart/alternative ]
Hello Manoj,

there are several possibilities to join 2 physical files in PF

Select *
    from  FILE1 a, FILE2  b
    where  a.KeyFld1 = b.KeyFld1 and  a.KeyFld2=b.KeyFld2 ....
        and a.cond1 = b.cond1

or

Select *
    from File1 a join File2 b
         on a.KeyFld1=b.KeyFld1 and a.KeyFld2 = b.KeyFld ...
    where a.Cond1 = b.Cond1

Depending on what you want you can use LEFT OUTER JOIN or
EXCEPTION JOIN,
too.

Birgitta
_______________________________________________
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.

__________________________________________________________
Give your Company an email address like
ravi @ ravi-exports.com.  Sign up for Rediffmail Pro today!
Know more. http://www.rediffmailpro.com/signup/