To create one mapping from more than one database table, select the mapping method By entering an SQL statement in the Data Access Builder SmartGuide Step - Select Database and Mapping Method. When you enter the SQL statement, you can use table joins in the statement, as shown in the following example:
SELECT PROJNO, PROJNAME, DEPTNO, RESPEMP, LASTNAME,
SALARY+BONUS+COMM
AS TOTAL_PAY FROM PROJECT, EMPLOYEE
The resulting schema icon
in the Data Access
Builder window represents a logical grouping of all the specified
columns in your SQL statement. The mapping for the schema is
created so that you can generate classes that access data from
table joins. Some methods are not generated for table joins, for
details see Table Joins and
Query Support.
