Tweet
Dear All, I know to put left outer join by using SQL Can you please tell me is it possible to use left outer join through WRKQRY tool. Is it possible??? Thanks Kapil
-
-
Left Outer Join
Kapil, When joining files in Query/400 there are 3 options available. After you select your files you will be taken to a second screen to select the type of join you want. 1= Matched, 2= Matched with primary file and 3= Unmatched with primary file. A left outer join would be 2= Matched with primary file. Vilena
Comment