How to manually join tables (Enterprise Manager)

To manually join tables

1. Add to the Diagram pane the tables you want to join.
2. Drag the name of the join column in the first input source window and drop it onto the related column in the second input source window. You cannot base a join on memo or binary (BLOB) columns.

   ---

   Note The join columns must be of the same (or compatible) data types. For example, if the join column in the first table is a date, you must relate it to a date column in the second table. On the other hand, if the first join column is an integer, the related join column must also be of an integer data type, but it can be a different size. The Query Designer will not check the data types of the columns you use to create a join, but when you execute the query, the database will display an error if the data types are not compatible.

   ---

3. If necessary, change the join operator; by default, the operator is an equal sign (=). For details, see Modifying Join Operators.

   The Query Designer adds an INNER JOIN clause to the SQL statement in the SQL pane. You can change the type to an outer join. For details see Creating Outer Joins.