PDA

View Full Version : Left Outer Join



Guest.Visitor
01-30-2006, 05:30 AM
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

kapil1
01-30-2006, 05:30 AM
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