Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Left Outer Join

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Left Outer Join

    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

  • #2
    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

    Working...
    X