Auto Joins

From DBArtisan
Jump to: navigation, search

Go Up to Using Query Builder

Query Builder includes an automatic join function that displays joins between selected tables and views in the SQL Diagram Pane. The Auto Join function seeks columns with the same name and data type. You can set global automatic join parameters in the Options Editor.

You can use the Statement Properties Editor to set local join parameters for the current Query Builder session without changing the global parameters.

Using Auto Join

To use Auto Join, do the following:

  1. On the Query Builder menu, click Auto Join.
    Query Builder joins columns in the SQL Diagram Pane.

Topics