Re: Join two PF using SQL

--
[ 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