Knowledge Base

PRB: Creating Join in Join Condition Dialog Box Creates Filter

Article ID: 192860

Article Last Modified on 12/11/1999


APPLIES TO


This article was previously published under Q192860

SYMPTOMS

When creating a remote view though the View Designer, if a join condition is specified in the Join Condition Dialog box, the join condition is specified as a filter rather than a join.

RESOLUTION

If you desire to use the Join syntax, you should use the Join tab to specify your join condition. You can also use the CREATE SQL VIEW command to create the remote view.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a remote view though the View Designer.
  2. Add two related tables, and note that the Join Condition dialog box is displayed.
  3. Create a join in that dialog and close the dialog.
  4. Click the Join tab in the View Designer, and note that there is no join specified there.
  5. Click the Filter tab in the View Designer. Note that there is a filter entered that matches the join condition specified in the Join Condition dialog box.

Additional query words: kbDSupport KBDSE kbVFp600 kbDatabase KbDBFDBC kbDesigner

Keywords: kbprb KB192860