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