A script-enabled browser is required for this page to function properly.

Removing unmatched rows (Query Builder)

To remove an unmatched relationship:

  1. In the Query window, click the relationship line that connects your target tables.
  2. Click the Set Table Relationship button in the Icon Bar to display the Set Relationship dialog box.
  3. Click Suppress Mismatches.
  4. Click OK.

See also

About unmatched (null) rows (Query Builder)

Creating an unmatched relationship (Query Builder)