
To define the mappings we select the column of the database in the tables view and its corresponding XML element or attribute in the XML view and then add the mapping to our definition. Since we are using two tables we have to specify the join conditions.
Click Mapping—>Edit Join Conditions.
Remember that we are using flightNo as a primary key, so they must match in both tables. See Figure
Figure 9-15 Edit Join Conditions
The complete definition is stored in passengerList.rmx, which is an abstract representation of the mapping.
Chapter 9. Developing XML Web services 197