Joining two tables

You can create a view for an SQL query for joining two tables. The table joins can be stored as views and executed.
Before you begin
About this task
To join two tables:
  1. Start IBM® InfoSphere™ Data Architect and load the data model.
  2. Right-click the schema where you want to add the view and click Add Data Object > View.
  3. Type a name.
  4. In the Project Explorer view, right-click the view you added and enter the SQL statement for the table join.
  5. In the Project Explorer view, right-click the table to which you want to run the join and click Apply View.
  6. Select the tables to which views should be applied.
  7. Click Finish.

Feedback