Creating join conditions

You can join tables from your database and map your database columns to elements or attributes (nodes) in the target XML file.

The following instructions were written for the Resource perspective, but they will also work in many other perspectives.

 

 

Joining database tables

If you are mapping more than one database table, you can create join conditions between the tables.

Follow these steps to create a join condition:

1. Open your mapping in the RDB to XML mapping editor.

2. Click Mapping > Edit Join Conditions. The Edit Join Conditions dialog opens.

3. Select the first row, then click the first Column cell and select a column from the list. The = condition is automatically applied and cannot be changed.

4. Select the first row, then click the third Column column and select the column that you want to join.

5. Starting on the second row, repeat the previous two steps until all of your join conditions are created. An AND condition is automatically applied when you have more that one join.

6. Click Finish.

Follow these steps to remove a join condition:

1. Open your mapping in the RDB to XML mapping editor.

2. Select Mapping > Edit Join Conditions. The Edit Join Conditions dialog opens.

3. Right-click the condition you want to remove.

4. Select Remove Join Condition.

5. Click Finish.

 

Parent topic

Editing an RDB to XML mapping

Related concepts
Relational database to XML mapping (visual DAD builder)

Related tasks
Specifying the source tables and target DTD file
Editing an RDB to XML mapping
Creating the mapping for an RDB_node DAD file
Creating the mapping for an SQL statement DAD file